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

ISSUE:

Getting below error message while trying to add Functional Administrator responsibility to sysadmin user.

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

CAUSE:

The ORA-20001 error is often caused by the responsibility that is already assigned.

Issue exists in R12 installation,upgradation and migration.


SOLUTION:

Please run the below concurrent programs in the order given, with the respective values of the parameters, and then retest the issue.

1. Run concurrent program "Workflow Directory services user/role validation" with argument values as 10000:Yes:Yes:No:NULL.

2. If Responsibility not showing in list, do below step

3. Bounce opmn services.

Now you can able to see responsibility.