APPLYING PUM 24: ERROR: RUN POST DATE CONVERSION AE - PODC26365794

(Doc ID 2321198.1)

Last updated on OCTOBER 25, 2017

Applies to:

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

Symptoms

HCM 9.2
PeopleTools 8.55
APPLYING PeopleSoft Update Image 24

Error running POST DATE CONVERSION AE - PODC26365794

ERRORS

--------------------------------------------------
File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 49 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_HCTS_CFG_TBL_FL SET EP_REVIEW_TYPE = ( SELECT EP_REVIEW_TYPE FROM PS_HCTS_SETUP_TBL) , HCTS_LOSSRSK_LABEL = ( SELECT HCTS_LOSSRSK_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_IMPACT_LABEL = ( SELECT HCTS_IMPACT_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_PERF_AXIS = ( SELECT HCTS_PERF_AXIS FROM PS_HCTS_SETUP_TBL) , HCTS_PERF_LABEL = ( SELECT HCTS_PERF_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_POTENTL_AXIS = ( SELECT HCTS_POTENTL_AXIS FROM PS_HCTS_SETUP_TBL) , HCTS_POTENTL_LABEL = ( SELECT HCTS_POTENTL_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_HIDE_RTBX1 = ( SELECT HCTS_HIDE_RTBX1 FROM PS_HCTS_SETUP_TBL) , HCTS_HIDE_RTBX2 = ( SELECT HCTS_HIDE_RTBX2 FROM PS_HCTS_SETUP_TBL) WHERE EXISTS( SELECT 'X' FROM PS_HCTS_CFG_TBL_FL B)

Message Set Number: 200
Message Number:

Message Reason: File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 49 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_HCTS_CFG_TBL_FL SET EP_REVIEW_TYPE = ( SELECT EP_REVIEW_TYPE FROM PS_HCTS_SETUP_TBL) , HCTS_LOSSRSK_LABEL = ( SELECT HCTS_LOSSRSK_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_IMPACT_LABEL = ( SELECT HCTS_IMPACT_LABEL FROM PS_HCTS_SETUP_TBL) , HCTS_PERF_AXIS = ( SELECT HCTS_PERF_AXIS FROM PS_HCTS_SETUP_ (200,0)
Process 923874 ABENDED at Step PODC26365794.MAIN.Step01 (SQL) -- RC = 1427 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 923874 ABENDED at Step PODC26365794.MAIN.Step01 (SQL) -- RC = 1427 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action

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