Disclaimer

These scripts come without warranty of any kind. Use them at your own risk. I assume no liability for the accuracy, correctness, completeness, or usefulness of any information provided by this site nor for any sort of damages using these scripts may cause.
Showing posts with label Oracle error-20001. Show all posts
Showing posts with label Oracle error-20001. Show all posts

Sunday, May 30, 2021

Oracle error-20001:APP-FND-01972: When Trying To End Date A Responsibility

 EBS Release 12.1.3


When trying to end_date a responsibility that is assigned to a user an error occurs.

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

This is caused by invalid data in the workflow user/Role table.

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

4. Retry to update the responsibility