Skip to content

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

workflow directory services

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: