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 AUGUST 10, 2017

Applies to:

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


Symptom 1:

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

oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-01436: CONNECT BY loop in user data
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



To view full details, 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 a vibrant support community of peers and Oracle experts.