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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.