This is often experienced in Oracle Applications 11i/R12 that user has been
assigned a responsibility but not able to see it while accessing it.
However , everything seems fine with responsibility ,it is not end dated
and looks good. To overcome this issue , there is a concurrent request
that does sync up of such users and responsibility in 11i version.
Login as System Administrator --> Submit Concurrent Program ""Workflow Directory Services User/Role Validation' with parameters 10000, yes, yes
This request would check all users and assigned responsibilities and should sync up users with attached responsibilities , users should be able to view assigned responsibility now.
Login as System Administrator --> Submit Concurrent Program ""Workflow Directory Services User/Role Validation' with parameters 10000, yes, yes
This request would check all users and assigned responsibilities and should sync up users with attached responsibilities , users should be able to view assigned responsibility now.
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)
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)
3 comments:
Super Jaggu
good one
Hi.
I support an Oracle application at a University in London, and I have been stumped on how to remove an End Date (i.e., Effective Date, To) against a ROLE.
Manual attempts to delete throught the UI have failed as they generate "ORA-20001: FND_CANT_UPDATE_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT" error when attempting to SAVE the update.
Also attempted the following (as supplied by a colleague) via System Administrator access in Function>Requests>Run...
1. Run "Workflow Directory Services User/Role Validation" with the following parameters:
Default Batchsize=10000
Fix Dangling User/Roles=Yes
Add Missing User/Role Assignments=No
2. Run "Workflow Directory Services User/Role Validation" with the following parameters:
Default Batchsize=10000
Fix Dangling User/Roles=No
Add Missing User/Role Assignments=Yes
...but this has also unfortunatley failed to either remove the ROLE completely (and reapply it as active (with blank End Date)), or simply to remove the End Date from the existing ROLE.
All of the above, of course, has been performed in a non-PRD environment prior to deploying any successful resolution in PRD.
Very grateful if you could advise on a succinct summary of steps that I can action.
Many thanks,
Norddin Yachou
Functional Analyst
Post a Comment