Intermittent APP-FND-01971 Failure Adding Responsibility To User

(Doc ID 1992419.1)

Last updated on AUGUST 29, 2016

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.

Symptoms

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 DHE 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."

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms