Attempting to Use "Paste" Function in Position Hierarchy Diagrammer, Error's: ORA-01436: CONNECT by loop in user data

(Doc ID 1638649.1)

Last updated on JULY 19, 2016

Applies to:

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


  When attempting to move a position to a new place in the hierachy by cut and paste the following error occurs.

  ORA-01436: CONNECT by loop in user data
  ORA-06512: at "APPS.HR_POS_HIERARCHY_ELE_API", line 197
  ORA-06512: at "APPS.HR_POS_HIERARCHY_ELE_API", line 430
  ORA-06412: at line 1

Steps to Reproduce:
  The issue can be reproduced at will with the following steps:

  1. Workstructures > Position > Diagrammer
  2. Open hierarchy
  3. Cut position
  4. Paste to a new location
  5. Error occurs


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