Wednesday, 3 December 2014

HOW TO CLEAR CACHE IN R12/11i

Login Issue First we have to check no user connected to application then follow

select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

then goto
system navigation >
     logging functional administrator responsibility >
                     core services  >
                             caching core service>
                                            global services >
                                                           clear all caches
Suppose you don't have permission to logging functional administrator , then



HOW TO CLEAR CACHE IN R12 WITHOUT FUNCTIONAL RESPONSIBILITY  
1. delete _pages and compile it manually
   $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2

or

2. Best way to clear cache modify context file parameter file
s_jsp_main_mode default value is justrun , simple change to recompile
"s_jsp_main_mode" value to recompile
jsp pages automatic recompile after modify s_jsp_main_mode

HOW TO CLEAR CACHE IN ORACLE 11i
previously it done by $COMMON_TOP/_pages and delete all files
1. stop Apache - adapcctl.sh stop apps/***
2. goto $comman_top/_pages
3. delete - $rm -rf *.*
4. start apache - adapcctl.sh start apps/***

In 11i Jps pages automatic compile , here jserv handle jsp pages but in R12 it taken care by OC4J , if directly clear _pages you will get blank screen issue , so it recommended when ever clear cache always complie jsp manually

$FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2

COMMON ISSUE : BLANK LOGGING PAGES  
Error:
javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException: Missing class: _AppsLocalLogin
Solution:
1. shut down application services
2. compile jsp manually
3. Restart application services
4. clear browser cache
5. Try to logging pages

No comments: