My Oracle Support Banner

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 JUNE 02, 2021

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 hierarchy 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




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

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