My Oracle Support Banner

Intermittent APP-FND-01971 Failure Adding Responsibility To User (Doc ID 1992419.1)

Last updated on MAY 19, 2024

Applies to:

Oracle Workflow - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Oracle User Management - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Encountering an intermittent ORA-20001, APP-FND-01971 failure on adding responsibility to user.

This can be produced with the following steps:
1. Have a few errors on adding responsibility to a user.
2. The addition of a responsibility failed to complete with the following error:

"Oracle error-2001: ORA-20001: APP-FND-01971: Error in FND_USER_RESP_GROUPS_API.Insert_Assignment: Cannot insert this row because there is already a direct assignment of the user <username> to the role FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD in the Workflow User/Role tables. has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT."





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

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