Receive Error Ora-20002: 4016 User/Role relationship ... Already Exists when Trying to Assign a Security Profile (Doc ID 1662225.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle User Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Human Resources - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In HR "Assign Security profiles" form, it is possible to assign a security profile to a user/responsibility, with the responsibility being an indirectly assigned responsibility (ie resp was assigned to the user via a role).

However, when trying to assign a security profile to same user but for a second responsibility that was also indirectly assigned via the same role, it throws the below error:


ERROR
-----------------------
Oracle error -20002: Ora-20002: 4016 User/Role relationship for user 'Username' and role
'FND_RESP|PER|XX_RESP_RP_P_O|81' already exists. has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT.


Additional information:

Here is the sequence of operations that leads to the problem:

1) create a test user (System administrator > User > Define)
2) create 2 responsibilities (System administrator > Responsibility > Define)
3) create a role (User Management > Role & Role Inheritance)
4) assign a first responsibility to the role (User Management > Role & Role Inheritance)
5) assign the role to the user (User Management > Users)
6) assign a security profile to the responsibility assigned to the user (HRMS Manager>>Security>>Assign security profile)
it works
then
7) assign the second responsibility to the role (User Management > Role & Role Inheritance)

8) Try to assign a security profile to this second responsibility assigned to the user (HRMS Manager>>Security>>Assign security profile).
=> The error gets thrown here

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