ORA-20001 FND_CANT_INSERT_USER_ROLE
I am getting below error message when I am trying to add Functional Administrator responsibility to sysadmin user.
Error :
ORA-20001 FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN) (ROLENAME=FND_RESP|FND|FND_FUNC_ADMIN|STANDRARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT
Solution :
If we trying to assign particular responsibility to user but we can’t and also It seems look like the user has been already assigned that responsibility but user can’t able to access that responsibility. To overcome this issue, there is a concurrent request that does sync up of such users and responsibility in R12 version.
Concurrent request :
Workflow Directory Services User/Role Validation with parameters 10000, yes, yes, no
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