Matrix Tree Build Issues With Multiple Jobs (Doc ID 2168616.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Matrix tree build is erroring.

ERROR

-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error
Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0811N The result of a
scalar fullselect, SELECT INTO statement, or VALUES INTO statement is more
than one row.
SQLSTATE=21000

[IBM][CLI Driver][DB2] SQL0965W There is no message text corresponding to
SQL warning "203" in the
Failed SQL stmt:
UPDATE PS_HR_JTR8_TAO
SET SUPERVISOR_ID =
( SELECT DISTINCT DR.SUPERVISOR_ID
FROM PS_HR_JTR8_TAO A ,
PS_HR_DIRECT_REP_2 DR
WHERE A.PROCESS_INSTANCE = 418573
AND DR.EMPLID = PS_HR_JTR8_TAO.EMPLID
AND DR.EMPL_RCD = PS_HR_JTR8_TAO.EMPL_RCD
AND A.EMPLID = DR.SUPERVISOR_ID
AND DR.DRILL_DOWN_FLAG = 'Y'
AND DR.HR_DR_LEVEL = ( SELECT MIN(HR_DR_LEVEL)
FROM PS_HR_DIRECT_REP_2 DR1
WHERE DR1.EMPLID = DR.EMPLID
AND DR1.EMPL_RCD = DR.EMPL_RCD
AND DR.DRILL_DOWN_FLAG = 'Y'
ND EXISTS ( SELECT 'X'
FROM PS_HR_DIRECT_REP_2 SUP1
WHERE DR1.SUPERVISOR_ID = SUP1.EMPLID
AND SUP1.EMPL_STATUS IN ('A' ,'L' ,'P' ,'S' ,'W') ) )) ,
SUPERVISOR_ERN = ( SELECT MIN(A.EMPL_RCD)
FROM PS_HR_JTR8_TAO A , PS_HR_DIRECT_REP_2 DR
WHERE A.PROCESS_INSTANCE = 418573
AND DR.EMPLID = PS_HR_JTR8_TAO.EMPLID
AND DR.EMPL_RCD = PS_HR_JTR8_TAO.EMPL_RCD
AND A.EMPLID = DR.SUPERVISOR_ID
AND DR.DRILL_DOWN_FLAG = 'Y'
AND DR.HR_DR_LEVEL =
( SELECT MIN(HR_DR_LEVEL)
FROM PS_HR_DIRECT_REP_2 DR1
WHERE DR1.EMPLID = DR.EMPLID
AND DR1.EMPL_RCD = DR.EMPL_RCD
AND DR.DRILL_DOWN_FLAG = 'Y'
AND EXISTS ( SELECT 'X'
FROM PS_HR_DIRECT_REP_2 SUP1
WHERE DR1.SUPERVISOR_ID = SUP1.EMPLID
AND SUP1.EMPL_STATUS IN ('A' ,'L' ,'P' ,'S' ,'W') ) )),
PARENT_NODE_NAME = ' '
WHERE PROCESS_INSTANCE = 418573
AND TREE_LEVEL_NUM > 1
AND EXISTS ( SELECT 'X' FROM
PS_HR_JTR8_TAO A ,
PS_HR_DIRECT_REP_2 DR
WHERE A.PROCESS_INSTANCE = 418573
AND A.EMPLID = DR.SUPERVISOR_ID
AND DR.DRILL_DOWN_FLAG = 'Y'
AND DR.HR_DR_LEVEL = ( SELECT MIN(HR_DR_LEVEL)
FROM PS_HR_DIRECT_REP_2 DR1
WHERE DR1.EMPLID = DR.EMPLID
AND DR1.EMPL_RCD = DR.EMPL_RCD
AND DR.DRILL_DOWN_FLAG = 'Y'
AND EXISTS ( SELECT 'X'
FROM PS_HR_DIRECT_REP_2 SUP1
WHERE DR1.SUPERVISOR_ID = SUP1.EMPLID
AND SUP1.EMPL_STATUS IN ('A' ,'L' ,'P' ,'S' ,'W') ) )
AND DR.EMPLID = PS_HR_JTR8_TAO.EMPLID
AND DR.EMPL_RCD = PS_HR_JTR8_TAO.EMPL_RCD
AND A.TREE_LEVEL_NUM = PS_HR_JTR8_TAO.TREE_LEVEL_NUM-1)

.

Process 418573 ABENDED at Step HR_TREEBLD_E.22SET23.Step1000 (SQL) -- RC =
8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s)

 

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