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 AUGUST 09, 2019

Applies to:

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

Symptoms

  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

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
References


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