My Oracle Support Banner

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 MAY 30, 2018

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.

Symptoms

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.

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.