Error When Building Company Directory Tree With Build Method: Supervisor Id (Doc ID 1670490.1)

Last updated on JUNE 02, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the Job Tree Builder Process, the following error occurs.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_HR_JTR8_TAO) violated
Failed SQL stmt: INSERT INTO PS_HR_JTR8_TAO (PROCESS_INSTANCE , TREE_NODE , EMPLID , EMPL_RCD , EMPL_STATUS , SUPERVISOR_ID , SUPERVISOR_ERN , PARENT_NODE_NAME , TREE_LEVEL_NUM ) SELECT 447822 , MIN(T.TREE_NODE) , DR.EMPLID , DR.EMPL_RCD , DR.EMPL_STATUS , '21683' , 0 , '21683000000000001443' , DR.HR_DR_LEVEL FROM PS_HR_DIRECT_REP_2 DR , PS_HRCD_JOB_TREE T , PS_PRIMARY_JOB_VW P WHERE DR.SUPERVISOR_ID = '21683' AND T.TREE_NODE <> '21683000000000001443' AND DR.DRILL_DOWN_FLAG = 'Y' AND DR.SUPERVISOR_FLAG = 'Y' AND DR.EMPLID = T.EMPLID AND DR.EMPL_RCD = T.EMPL_RCD AND DR.EMPLID = P.EMPLID AND DR.EMPL_RCD = P.EMPL_RCD AND P.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PRIMARY_JOB_VW WHERE EMPLID = P.EMPLID AND EFFDT
Process 447822 ABENDED at Step HR_TREEBLD_E.22SET23.Step0500 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Set Up HRMS > Common Definitions > Org Chart Viewer > Job Tree Builder and select ' By Supervisor Id' as Build Method and Action as 'Create/Replace Tree' and it runs to no success


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