Any Action Requiring Approval Errors Out With: ORA-01436: Connect By Loop In User Data

(Doc ID 357718.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12 and later
Information in this document applies to any platform.

Symptoms

Symptom 1:

Navigating to the review page in SSHR using any function that requires approval.
Getting an error an unable to continue.

ERROR STACK
-----------------
oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-01436: CONNECT BY loop in user data
ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 502
ORA-06512: at line 1
...

 

Symptom 2

Saving an insert or update of an assignment for the employee

FRM-40735 On Update Trigger raised unhandled exception ORA-01436

in trace file the following error :

ORA-01436: Connect By Loop

 

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