My Oracle Support Banner

ORA-20002 Occurs When Changing From Date for a Future Employee in Form "USERS"(FNDSCAUS) (Doc ID 1906433.1)

Last updated on JULY 28, 2019

Applies to:

Oracle Workflow - Version 12.1.3 and later
Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to change 'From' date in the Define Users screen, 'Direct Responsibilities' tab, the following error is raised

Error
------
Oracle error -20002: ORA-20002: 4016 User/Role relationship
for user 'xxxx' and role
'FND_RESP|PER| AKAJP_HRMS_MANAGER|STANDARD' already exists.
has been detected in FND_USER_RESP_GROUPS_API.UPDATE_ASSIGNMENT.


Steps to reproduce

1. Enter a future employee in field "Person" of form"Users"(FNDSCAUS) to link a person to a user.
    Responsibility:System Administrator
    (N) Security -> User -> Define

2. Wait until the effective date when above employee is effective.

3. Run concurrent program"Synchronize WF LOCAL tables" to link above employee to the user.
    Responsibility:System Administrator
    (N) Concurrent -> Requests

4. Change From date in tab"Direct Responsibilities" and Save

5. Change From date again and the error happens after clicking the button "Save".



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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.