When we have to clear OAFM cache in oracle EBS-R12/R12.2
WARNING: 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.
Below example how to clear cache in Oracle EBS12.2
before executing below commands make sure env should be source properly
check location before executing below commands
Manytimes when setting profile options that pertain to iProcurement,
to ensure that the new profile values are invoked immediately, the following actions can be taken using the Functional Administrator.
Examples that may require this action to be taken are as follows:
- iProcurement Preferences (these values actually are User level profile options)
- FND Diagnostics - to enable diagnostics
- FND Debug Log Enabled - which engages further debugging to FND_LOG_MESSAGES table
- Personalize Self Service Defn - commonly used profile to enable the Personalization Links
- Newly added responsibility is not visible in the list of Responsibilities after logging into the application
The following steps are to be utilized to clear all the cache,forcing a refresh and requery of all profile values for the user in question.
1. Login and choose the Functional Administrator responsibility - then choose Home.
2. 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
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.
- In the far right choose 'Clear all Cache' button
WARNING: 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.
Below example how to clear cache in Oracle EBS12.2
before executing below commands make sure env should be source properly
check location before executing below commands
Manytimes when setting profile options that pertain to iProcurement,
to ensure that the new profile values are invoked immediately, the following actions can be taken using the Functional Administrator.
Examples that may require this action to be taken are as follows:
- iProcurement Preferences (these values actually are User level profile options)
- FND Diagnostics - to enable diagnostics
- FND Debug Log Enabled - which engages further debugging to FND_LOG_MESSAGES table
- Personalize Self Service Defn - commonly used profile to enable the Personalization Links
- Newly added responsibility is not visible in the list of Responsibilities after logging into the application
The following steps are to be utilized to clear all the cache,forcing a refresh and requery of all profile values for the user in question.
1. Login and choose the Functional Administrator responsibility - then choose Home.
2. 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
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.
- In the far right choose 'Clear all Cache' button
3. A confirmation message is displayed, confirming that all cache has been cleared across middle tiers.
4. Proceed to test and confirm whatever change was made to the preference, profile, etc..
How to clear cache in Oracle EBSR12?
Note:This method applies for Oracle EBS R12 and it is not recommended method,only have to do if you are not able to login page itself.
When to perform OAFM Cache clear/persistence clear?
1.If login page is showing blank after clone
2.If apache service is not coming up
3.When ever we bounce middle tier services best practice to clear OAFM cache from front end using Functional Administrator Responsibility.
example:
applmgr@node101]$rm -rf $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
applmgr@node101]$rm -rf $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
applmgr@node101]rm -rf $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*
applmgr@node101]rm -rf $INST_TOP/ora/10.1.3/opmn/logs/states/.opmndat
Thank you for useful post!
ReplyDeleteAssalamualikum Mr.Anwar Taz this is Mohammed Abdul Haq
ReplyDeleteThanks