Wednesday, 23 February 2011

Responsibility not visible to user in Oracle Applications R12

Today I encountered this issue on a fully functional R12 instance.
1) Login as sysadmin or any user who as privileges to create user/add responsibilities

2) Create a new user and add responsibilities or add additional seeded/custom responsibilities to existing user
Then,

3) New/existing user logs in but he/she cant see the new responsibility.

Strange right?

To tackle this situation, I ran this concurrent program “Workflow Directory Services User/Role Validation” with below parameters:

p_BatchSize – 10000 (Default Value 10000)
p_Check_Dangling – Yes (Default value No)
Add missing user/role assignments – Yes (Default Value No)
Update WHO columns in WF tables – No (Default Value No)

So what does this concurrent program do. It syncs all the user and role related WF tables with latest information viz., WF_LOCAL_ROLES, WF_LOCAL_USER_ROLES, WF_USER_ROLE_ASSIGNMENTS etc.,

The time taken to complete this program depends on the number of users/roles to be synched. After completion of this request the affected user can log back in to see the missing responsibilities.

FYI, You can also schedule this request to run every 15 minutes or so, but it depends how frequently you create/assign new users/roles/responsibilities.

Have Fun,
Akhil

No comments:

Post a Comment