Wednesday 6 January 2016

During Oracle Apps Login, Responsibilities Assigned to Users is not appearing in the Navigator Page

While User Login on Oracle Application then some time Responsibility not showing to user then use the below steps to resolve this issue. 

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid. To synchronize data follow the steps below.


1. Navigate to the define user form (FNDSCAUS).
2. Query up the user (that is having the issue) and insure the responsibility is NOT end dated. 
3. END DATE the USER (not the responsibility) and save the record. 
4. UNEND DATE the USER and save the record. 
5. Run the request 'Sync responsibility role data into the WF table'.
6. Run the request "Synchronize WF LOCAL tables". 
7. Run the request "Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes). 
8. Have the user log off and back on and verify that the responsibility appears.

After that clear the apache cache.

How to clear Apache Cache from Application without bouncing listener.

1. Navigate to "Functional Administrator" responsibility.
2. Once logged in click on the "Core Services" tab.
3. Click on "Caching Framework" link in the blue menu bar.
4. Click on "Global Configuration" link in the left vertical menu.
5. In the "Cache Policy" region click on the "Clear All Cache" button.
6. Click the "Yes" button to confirm the action.
7. Click the "Apply" button to apply the changes.

The above steps will clear the apache cache without the need of bouncing by the DBA's


No comments:

Post a Comment