ORA-20002 and ORA-01436 When Removing an End Date for a Responsibility linked to a User

(Doc ID 1684506.1)

Last updated on JUNE 19, 2014

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Basic SysAdmin functions, maintenance

When attempting to update user to remove the end date,
the following error occurs.

ERROR
-----------------------
ORA-20002 ORA-20002 3825 Error: 1436
ORA-1436 CONNECT BY loop in user data
ORA-20002 WF_INVALID_USER_ROLE encountered during
execution of Rule function WF_ROLE_HIERARCHY.cascade_RF
for event oracle.apps.fnd.wf.ds.userRole.created with key
FND_USER:2530|FND_RESP:50710|...... has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Define Users form
2. Query the user
3. Remove user end date

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