During Data Conversion for PODC26365794.MAIN.Step01, ORA-00907: missing right parenthesis error occurs

(Doc ID 2354396.1)

Last updated on MARCH 07, 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

While applying HCM 9.20 PUM25 to an Oracle database on 11g, a row limiting clause error occurs. SELECT EP_REVIEW_TYPE FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY.

The SQL statement does not work in 11g (11.2.0.4.0).

ERROR
-----------------------
PeopleTools 8.55.20 - Application Engine
Copyright (c) 1988-2018 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85520c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 100 Return: 907 - ORA-00907: missing right parenthesis
Failed SQL stmt: UPDATE PS_HCTS_CFG_TBL_FL SET EP_REVIEW_TYPE = ( SELECT EP_REVIEW_TYPE FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_LOSSRSK_LABEL = ( SELECT HCTS_LOSSRSK_LABEL FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_IMPACT_LABEL = ( SELECT HCTS_IMPACT_LABEL FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_PERF_AXIS = ( SELECT HCTS_PERF_AXIS FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_PERF_LABEL = ( SELECT HCTS_PERF_LABEL FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_POTENTL_AXIS = ( SELECT HCTS_POTENTL_AXIS FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_POTENTL_LABEL = ( SELECT HCTS_POTENTL_LABEL FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_HIDE_RTBX1 = ( SELECT HCTS_HIDE_RTBX1 FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_HIDE_RTBX2 = ( SELECT HCTS_HIDE_RTBX2 FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) WHERE EXISTS( SELECT 'X' FROM PS_HCTS_CFG_TBL_FL B)

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt85520c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 100 Return: 907 - ORA-00907: missing right parenthesis
Failed SQL stmt: UPDATE PS_HCTS_CFG_TBL_FL SET EP_REVIEW_TYPE = ( SELECT EP_REVIEW_TYPE FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HCTS_LOSSRSK_LABEL = ( SELECT HCTS_LOSSRSK_LABEL FROM PS_HCTS_SETUP_TBL FETCH FIRST 1 ROWS ONLY) , HC


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply updates from PI25 including Bug 26365794
2. Proceed to step Running the Post Data Conversion AE PODC26365794 in Change Assistant
3. Error occurs

Changes

Error occurs for Oracle Database 11g and may occur for other databases

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