Wednesday, 30 May 2018

Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment. Cannot update this row because thee is no direct assignment of the user XXX to the role

Error:-

When attempting to add or remove an end_date  for a responsibility that is assigned to a user an error occurs.

Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment.
Cannot update this row because thee is no direct assignment of the user XXX to the role FND_RESP\CSM\OMFS_PLAM\STANDARD in the workflow user/Role table.
has been detected in FND_USER_RESP_GROUP_API.UPDATE_ASSIGNMENT.

Cause:-

The problem was caused by invalid data in the workflow user/Role table.

Solution:-

To implement the solution, please execute the following steps:

1. Go into the responsibility: System administrator.

2. Navigate to Requests > Run

3. Select request ''Workflow Directory Services User/Role Validation' and submit
    1. Run the program " Workflow Directory Services User/Role Validation" once with the following parameters:

        Fix Dangling User/Roles

            Default Batchsize=10000
            Fix Dangling User/Roles=Yes
            Add Missing User/Role Assignments=No

    2. After it completes, Add Missing User/Role Assignments

            Default Batchsize=10000
            Fix Dangling User/Roles=No
            Add Missing User/Role Assignments=Yes

4. Retest the issue by trying to update the responsibility..

5. Migrate the solution as appropriate to other environments.

1 comment: