Monday, January 6, 2014

How to clear the cache for Oracle EBS R12 or Middle Tier Applications

We can clear the cache in Oracle EBS R12 or Middle Tier Applications using the below steps:

Note: Clearing the OA Framework cache in a PRODUCTION instance can cause data issues if multiple users are engaged and transacting data in the application at the time cache is cleared.  Please only utilize this in Production if advised by Oracle Support Services or Oracle Development.

Step1:Login and choose the Functional Administrator responsibility - then choose Home. As seen in below screenshot.

Step2:Choose the Core Services Tab - then the Caching Framework Sub-Menu (In the dark blue region).
 - Proceed to choose 'Global Configuration' from the left hand side menu that appears
 - In the far right choose 'Clear all Cache' button

Step3:A screen prompts and confirms that the action will clear all cache on the middle tier server - choose Yes.
Essentially, this just forces all user sessions to engage and validate - rather than using cached values.

Step4:A confirmation message is displayed, confirming that all cache has been cleared across middle tiers.

Step5:Proceed to test and confirm whatever change was made to the preference, profile, etc....

How To Clear The Cache Using Functional Administrator? [ID 759038.1]

Enjoy  doing Oracle Apps   DBA tasks.

Best regards,




  1. Very Nice Thoughts. Thanks For Sharing with us. I got More information about Java from Besant Technologies. If anyone wants to get Java Training in Chennai visit Besant Technologies.

  2. Thanks for sharing your innovative ideas..Its really useful and interesting...

    Oracle Training

  3. Thanks for sharing this interesting and useful blog..

    Oracle Training Chennai

  4. I get a lot of great information from this blog. Recently I did oracle certification course at a leading academy. If you are looking for best Oracle Course in Chennai visit FITA IT training and placement academy which offer best SQL Training in Chennai.