On The Core Users Screen Adding A Responsibility Fails with ORA-01436: CONNECT BY loop in user data (Doc ID 1591866.1)

Last updated on MARCH 20, 2015

Applies to:

Oracle Workflow Cartridge - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Using the Oracle Applications Release 12.1.3,
on the FNDSCAUS form, adding A Responsibility Fails with CONNECT BY LOOP error:

Oracle error -20002: ORA-20002: 385: Error ‘-1436 - 
ORA-01436: CONNECT BY loop in user data
ORA-20002: [WF_INVAL_USER_ROLE]’ encountered during execution of Rule function ‘WF_ROLE_HIERARCHY.Cascade_RF’ for event ‘oracle.apps.fnd.wf.ds.userRole.created’ with key ‘PER:131628|FND_RESP:50278|2456540:53667’. 
  Has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT’


The following steps can reproduce the problem:
1. Querying an existing Username on the Core ‘Users’ screen (FNDSCAUS)
2. Add the custom Responsibility ‘LCC Employee Self-Service V5.0’ or 'Oracle Seeded Responsibility' fails with the error
 
Alternate Step to reproduce the problem:
1. When using the Self-Service Users screen under ‘User Management’
2. Adding the Responsibility to the User the following error message is received:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: 
ORA-01436: CONNECT BY loop in user data 
ORA-06512: at "APPS.WF_ROLE_HIERARCHY", line 2421

Changes

Attempting to allow the relationship between active & inactive role relationships 

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