EGL9.2: 'Running The Configuration By Project Process' Abended at step FS_CFUPDATE.MAIN.SQL with "ORA-00942: table or view does not exist" (Doc ID 1663025.1)

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

Running Configuration By Project Process (in the Task 5-5-8), abended at step FS_CFUPDATE.MAIN.SQL with "ORA-00942: table or view does not exist"

Error:
------
SELECT B.FIELDNAME,A.BASE_RECNAME FROM PS_REC_MAPPING_TBL A, PS_FS_FLD_PROMPT B, PS_FS_CF_TEMPLATE C WHERE A.BASE_RECNAME = B.PROMPT_TBL AND A.REC_MAPPING_TYPE='SYN' AND C.FIELDNAME=B.FIELDNAME AND C.CF_ACTIVE_STATUS='A';


Message Set Number: 0
Message Number: 0
Message Reason: SQL error. Function: CreateSQL
Error Position: 39
Return: 942 - ORA-00942: table or view does not exist


Steps to Replicate:
-------------------

1. Execute Task 5-5-8: Running the Configuration by Project Process

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