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,