Sunday, September 8, 2013

Clear Middle Tier Cache in Oracle Applications R12

As we move forward we are giving farewell of most of Oracle Forms module in Oracle R12. Things are now moving to Java based. Many times we often face issue where some of our recent changes or deployed object are not working properly. Many time its because of the Middle Tier cache as object are getting picked from cache instead of getting new updated version.

In such case best ways it to clear Middle Tier cache and try again. Please follow below steps to clear Middle Tier cache.

- Login to Oracle Applications
- Navigate to Functional Administrator
- Core Services -> Caching Framework -> Global Configuration
- Click on Clear All Cache (It gives a warning message, click OK to proceed)
After few seconds it display the task completed and we are done!!!

How To Bounce Apache Server in Oracle E-Business R12

Generally in day to days usage of Oracle Apps R12 we came up many issue which is resolved by bouncing Apache Server like :-
 - JSP page not loading
 - Changes in are not appearing after done with personalization
 - Some weird java error.
Its really easy to get this done and not a big mans job any more.

#1 Login to Unix prompt with right privilege that can let you stop and start the services. Source and the environment variable.
login as: invincibleapps
Using keyboard-interactive authentication.
Enter your PASSWORD:
Last login: Sun Sep  8 17:36:19 2013
You are now pointed to invincibleapps Apps environment
[invincibleapps@dev ~]$ . /d01/appldev/invincibleapps/apps/apps_st/appl/APPSinvincibleapps_dev.env