ORA-20002 and ORA-01436 When Removing an End Date for a Responsibility linked to a User
(Doc ID 1684506.1)
Last updated on FEBRUARY 14, 2019
Applies to:Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Basic SysAdmin functions, maintenance
When attempting to update user to remove the end date,
the following error occurs.
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
The issue can be reproduced at will with the following steps:
1. Define Users form
2. Query the user
3. Remove user end date
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