DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, July 1, 2016

Error Oracle - 20001

Error Oracle - 20001

When trying  to assign responsibility to a user, the following error occurs.

ERROR
Error Oracle - 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE(USERNAME=AKUMAE) (ROLENAME=FND_RESP|INV|XXFM_ROUTIN_VIEW|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT


Screen Shot :




CAUSE FOR THIS ISSUE :
There is a conflict between the user's direct and indirect responsibility and role assignments.

Solution :
As this responsibility is already added to the user via roles, we need to remove the responsibility 'XXFM_ROUTIN_VIEW' from the user record. Once it is removed, the record can be successfully saved.




No comments: