Attempting To Remove End Date On A Responsibility Assignment Fails With Error ORA-20002 416 User/Role Relationship Already Exists
(Doc ID 1513982.1)
Last updated on OCTOBER 22, 2019
Applies to:Oracle User Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Workflow - Version 12.0.6 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
On R12.0.6, when trying to remove the end_date on the assignment of a responsibility to a user, the following error is displayed:
ORA-20002: 416: User/Role relationship for user 'XXX' and role FND_RESPS|SQLGL|RCUK_GL_SU|STANDARD' already exists. has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document