Error "ORA-00942: table or view does not exist. Process 1 ABENDED at Step UPG_SPL.SPLR13.SPL1301 (SQL) -- RC = 942 (108,524)" when Running the Upgrade UPDATACONV Process (Doc ID 847833.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

The following error is issued for the Data conversion Group 4 when running the initial pass of the upgrade UPDATACONV process:

Failed SQL stmt:INSERT INTO PS_PL_WB_ROWTYPE (PL_WBENCH_TYPE , PL_ROWTYPE , DESCR , DESCRSHORT , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM) SELECT PL_WBENCH_TYPE , PL_ROWTYPE , DESCR , DESCRSHORT , TO_DATE(TO_CHAR(ROW_ADDED_DTTM , 'YYYY-MM-DD-') || TO_CHAR( DECODE('00.00.00.000000', NULL, TO_DATE(NULL), TO_DATE(SUBSTR('1900-01-01-' || '00.00.00.000000', 0, 19), 'YYYY-MM-DD-HH24.MI.SS')), 'HH24.MI.SS'), 'YYYY-MM-DD-HH24.MI.SS') , ROW_ADDED_OPRID , TO_DATE(TO_CHAR(ROW_LASTMANT_DTTM , 'YYYY-MM-DD-') || TO_CHAR( DECODE('00.00.00.000000', NULL, TO_DATE(NULL), TO_DATE(SUBSTR('1900-01-01-' || '00.00.00.000000', 0, 19), 'YYYY-MM-DD-HH24.MI.SS')), 'HH24.MI.SS'), 'YYYY-MM-DD-HH24.MI.SS') , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM FROM PS_UPG_PL_WB_RTYPE

SQL error. Stmt #: 1603 Error Position: 769 Return: 942 - ORA-00942: table or view does not exist.

Process 1 ABENDED at Step UPG_SPL.SPLR13.SPL1301 (SQL) -- RC = 942 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 1 ABENDED at Step UPG_SPL.SPLR13.SPL1301 (SQL) -- RC = 942 (108,524)

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

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