Header Ads Widget

ORA-20001 : FND_CANT_INSERT_USER_ROLE (USERNAME = SYSADMIN)




I have faced below error while adding 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:

Applied following solution to come out from this error.

I ran concurrent request

"Workflow Directory Services User/Role Validation"

with following parameters

Batch Size : 10000
Fix Dialing Users : Yes
Add missing user/role assignements : Yes
Update WHO comuln in WF tables : No.



This concurrent request will sync users roles and responsibilities.

Now, Responsibility should be visible to user.