Any Action Requiring Approval Errors Out With: ORA-01436: Connect By Loop In User Data
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.
Navigating to the review page in SSHR using any function that requires approval.
Getting an error an unable to continue.
ORA-01436: CONNECT BY loop in user data
ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 502
ORA-06512: at line 1
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
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