Updating a Responsibility Fails with Error 'ORA-20001: FND_CANT_UPDATE_USER_ROLE' and 'ORA-06512: at APPS.FND_USER_RESP_GROUPS_API' When Using fnd_user_pkg.addresp or delresp (Doc ID 2110848.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3, System Administration Utilities

Encountering the following error when attempting to update a responsibility:


ERROR
-----------------------
ERROR at line 1:
ORA-20001: Oracle error -20001: ORA-20001: FND_CANT_UPDATE_USER_ROLE
USERNAME=M92E) (ROLENAME=FND_RESP|SQLGL|xxx_00180_WF_APPROVER|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Update_Assignment) has been detected in
FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 29
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 845
ORA-06512: at "APPS.FND_USER_PKG", line 2992
ORA-06512: at line 1 


STEPS
-----------------------
Execute the fnd_user_pkg.addresp or delresp.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms