My Oracle Support Banner

Any Action Requiring Approval Errors Out With: ORA-01436: Connect By Loop In User Data (Doc ID 357718.1)

Last updated on JUNE 07, 2021

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

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.