My Oracle Support Banner

Tree Builder Run Control for Company Directory With 'empty position' Checkbox Turned On Errors- "HR_TREEBLD Process 85961 ABENDED at Step HR_TREEBLD_P.21BlEPos.Step02 (SQL) -- RC = 8601 (108,524)" (Doc ID 2536309.1)

Last updated on JULY 22, 2020

Applies to:

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

Symptoms

Run the Job Tree Build process HR_TREEBLD from SetUp HCM > Common
Definitions > Org Chart Viewer > Tree Builder Run Control for Company
directory with 'empty position' checkbox turned on. The process failed with
syntax error.



Error:
======
HR_TREEBLD
Process 85961 ABENDED at Step HR_TREEBLD_P.21BlEPos.Step02 (SQL) -- RC = 8601
(108,524)

Failed SQL stmt: INSERT INTO PS_HR_JTREE_TAO( SUPERVISOR_ID , SUPERVISOR_ERN
, EMPLID , EMPL_RCD , TREE_NODE ,PARENT_NODE_NAME ,TREE_LEVEL_NUM
,EMPL_STATUS ,JOB_INDICATOR ,DRILL_DOWN_FLAG ,INDR_COUNT ,DR_COUNT ,
PROCESS_INSTANCE) SELECT DISTINCT DR.EMPLID , DR. EMPL_RCD , 'EP$'+
E.POSITION_NBR , 0 ,LEFT((LEFT(LEFT(E.POSITION_NBR,11)+ replicate('P',11), 11
)+'000')+ replicate('0',20),20) ,LEFT((LEFT(LEFT(DR.EMPLID,11)+
replicate('X',11), 11 )+ RIGHT(replicate(0,3)+(DR.EMPL_RCD,3),3))+
replicate('0',20),20) ,DR.TREE_LEVEL_NUM ,'A' ,' ' ,E.SUPERVISOR_FLAG ,0 ,0
,85961 FROM PS_HRDR_RPTTO_EMTY E ,PS_HR_DRTREE_TAO DR WHERE E.HR_DR_LEVEL = (
SELECT MIN(E1.HR_DR_LEVEL) FROM PS_HRDR_RPTTO_EMTY E1 WHERE E1.POSITION_NBR =
E.POSITION_NBR) AND E.REPORTS_TO = DR.POSITION_NBR AND DR.HR_DR_LEVEL = (
SELECT MIN(HR_DR_LEVEL) FROM PS_HR_DRTREE_TAO DR2 WHERE DR.POSITION_NBR=
DR2.POSITION_NBR) AND NOT EXISTS ( SELECT 'X' FROM PS_POSN_INCUMB_WS1 W WHERE
E.POSITION_NBR = W.POSITION_NBR) AND (EXISTS( SELECT 'X' FROM PS_HR_JTREE_TAO
JT WHERE DR.EMPLID = JT.EMPLID AND DR.EMPL_RCD = JT.EMPL_RCD) OR (DR.EMPLID =
'KU0001' AND DR.EMPL_RCD = 0) )

REPLICATION STEPS
=================
The issue can be reproduced at will with the following steps:
1. SetUp HCM > Common Definitions > Org Chart Viewer > Tree Builder Run
Control for Company directory with 'empty position' checkbox turned on.

2. Error occurs.

Changes

 

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