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

Cause

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