Run Post Data Conversion AE - PODC25452294 Process 3793726 ABENDED at Step PODC25452294.MAIN.Step01 (SQL) -- RC = 933 (108,524)
(Doc ID 2413429.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9 and laterInformation in this document applies to any platform.
Symptoms
The following error is occurring when running the Change Assistant:
PeopleTools 8.55.22 - Application Engine
Copyright (c) 1988-2018 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85522c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 746 Return: 933 - ORA-00933: SQL command not properly ended
Failed SQL stmt: INSERT INTO PS_HCTS_CFG_TBL_FL HCTS_REVIEW_TYPE , HCTS_PERF_RANGE , HCTS_COMP_RANGE , HCTS_COMPARE , HCTS_ALERT_DAYS , HCTS_PROJ_RANGE , EP_REVIEW_TYPE , HCTS_LOSSRSK_LABEL , HCTS_IMPACT_LABEL , HCTS_PERF_AXIS , HCTS_PERF_LABEL , HCTS_POTENTL_AXIS , HCTS_POTENTL_LABEL , HCTS_HIDE_RTBX1 , HCTS_HIDE_RTBX2 , HCTS_SP_DRAFT , HCTS_SP_OFFICIAL) SELECT A.HCTS_REVIEW_TYPE , A.HCTS_PERF_RANGE , A.HCTS_COMP_RANGE , 'N' , 0 , A.HCTS_PROJ_RANGE , A.EP_REVIEW_TYPE , A.HCTS_LOSSRSK_LABEL , A.HCTS_IMPACT_LABEL , A.HCTS_PERF_AXIS , A.HCTS_PERF_LABEL , A.HCTS_POTENTL_AXIS , A.HCTS_POTENTL_LABEL , A.HCTS_HIDE_RTBX1 , A.HCTS_HIDE_RTBX2 , A.HCTS_SP_DRAFT , A.HCTS_SP_OFFICIAL FROM PS_HCTS_SETUP_TBL A WHERE NOT EXISTS( SELECT 'X' FROM PS_HCTS_CFG_TBL_FL B) FETCH FIRST 1 ROWS ONLY
Message Set Number: 200
Message Number: 0
Message Reason: File: e:\pt85522c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 746 Return: 933 - ORA-00933: SQL command not properly ended
Failed SQL stmt: INSERT INTO PS_HCTS_CFG_TBL_FL (HCTS_REVIEW_TYPE , HCTS_PERF_RANGE , HCTS_COMP_RANGE , HCTS_COMPARE , HCTS_ALERT_DAYS , HCTS_PROJ_RANGE , EP_REVIEW_TYPE , HCTS_LOSSRSK_LABEL , HCTS_IMPACT_LABEL , HCTS_PERF_AXIS , HCTS_PERF_LABEL , HCTS_POTENTL_AXIS , HCTS_POTENTL_LABEL , HCTS_HIDE_RTBX1 , HCTS_HIDE_RTBX2 , HCTS_SP_DRAF (200,0)
Process 3793726 ABENDED at Step PODC25452294.MAIN.Step01 (SQL) -- RC = 933 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 3793726 ABENDED at Step PODC25452294.MAIN.Step01 (SQL) -- RC = 933 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
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 |