EGL9.2: FSCM 9.0 To 9.2 Upgrade Step Task 5-5-7: Importing Configuration Defaults Fails With SQL Error 'ORA-00942: table or view does not exist' (Doc ID 1582410.1)

Last updated on MARCH 20, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Issue:
--------

Upgrading from 9.0 to 9.2

When attempting to run DLCGFAZ19I.DMS, the following error occurs.

Error:
--------
SQL Error. Error Position: 65 Return: 942 - ORA-00942: table or view does not exist


DELETE FROM PS_CA_CONS_DTL_BAK where NOT EXISTS (SELECT 'X' FROM PS_CA_CONS_DTL_TPL A, PS_FS_CF_TEMPLATE B where B.FIELDNAME = A.FIELDNAME AND B.ORIG_CF_NAME <> B.FIELDNAME AND (B.CF_TYPE ='F' OR B.AFFILIATE_TYPE = 'A') AND A.SETID=PS_CA_CONS_DTL_BAK.SETID AND A.CONS_TPL_ID=PS_CA_CONS_DTL_BAK.CONS_TPL_ID AND A.RECORDNAME=PS_CA_CONS_DTL_BAK.RECORDNAME AND B.ORIG_CF_NAME=PS_CA_CONS_DTL_BAK.FIELDNAME )
Error: SQL execute error for DELETE FROM PS_CA_CONS_DTL_BAK where NOT EXISTS (SELECT 'X' FROM PS_CA_CONS_DTL_TPL A, PS_FS_CF_TEMPLATE B where B.FIELDNAME = A.FIELDNAME AND B.ORIG_CF_NAME <> B.FIELDNAME AND (B.CF_TYPE ='F' OR B.AFFILIATE_TYPE = 'A') AND A.SETID=PS_CA_CONS_DTL_BAK.SETID AND A.CONS_TPL_ID=PS_CA_CONS_DTL_BAK.CONS_TPL_ID AND A.RECORDNAME=PS_CA_CONS_DTL_BAK.RECORDNAME AND B.ORIG_CF_NAME=PS_CA_CONS_DTL_BAK.FIELDNAME )


Replication Steps:
-----------------------
The issue can be reproduced at will with the following steps:
1. Download and apply PUM Image 1
2. Run DLCGFAZ19I.DMS from Task 5-5-7: Importing Configuration Defaults in 9.0 - 9.2 upgrade document

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