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....
References:

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

Enjoy  doing Oracle Apps   DBA tasks.


Best regards,

Rafi







 

12 comments:

  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.

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


    Oracle Training

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

    Oracle Training Chennai

    ReplyDelete
  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.

    ReplyDelete
  5. Oracle Training in chennai I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..

    ReplyDelete
  6. Hi
    Quite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.
    Regards,
    Oracle Training in Chennai|Oracle DBA Training in Chennai|Oracle Training Institutes in Chennai

    ReplyDelete
  7. We offer Pentaho BI Training in practical way to ensure our participants acquire understanding all concepts and features very well.
    Pentaho Training | Selenium Training| Python Training | LoadRunner Training | WebSphere Training | Node.js Training

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    microservices online training
    best microservices online traiing
    top microservices online training

    ReplyDelete