During Data Conversion for AE PODC25452294 Step Fails with SQL command not properly ended

(Doc ID 2384833.1)

Last updated on APRIL 10, 2018

Applies to:

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

Symptoms

When attempting to Run Post Data Conversion AE PODC25452294,the following error occurs.

ERROR
-----------------------
File: e:\pt85520c-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:\pt85520c-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 2861200 ABENDED at Step PODC25452294.MAIN.Step01 (SQL) -- RC = 933 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 2861200 ABENDED at Step PODC25452294.MAIN.Step01 (SQL) -- RC = 933 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Data conversion step
2. Run AE PODC25452294


Changes

 

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