ORA-20002 [WF_NO_USER] Error in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT When Adding Responsibilities to an FND User Associated with an Employee (Doc ID 2313934.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Symptoms

When attempting to add responsibilities to the FND user of an employee, who is not a future hire, the following error occurs.

The solutions provided in the note below do not fix the issue:

<Note 1936648.1> - ORA-20002 [WF_NO_USER] While Adding Responsibilities To Newly Created Apps Users Who Are Future Dated Employees

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Log on to the Applications.

2. Choose the responsibility System Administrator.

3. N-> Security-> User-> Define.

4. Enter the details of the user.

5. Enter the name of the HR employee, who the account is for, via the Person field.

6. Save the record.

7. Attach a responsibility to the account.

8. Save the changes.

Changes

 Upgraded the Oracle database from 11g to 12c

Cause

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