My Oracle Support Banner

EGL9.2.Running Data Conversion AE- DCGL23233320 Step Failed With Error :"ORA-00942: table or view does not exist Failed SQL stmt: DELETE FROM PS_EOAW_SUMMARY WHERE EOAWPRCS_ID='GLJournalApproval' AND ((EOAWTHREAD_ID NOT IN ( SELECT EOAWTHREAD_ID FROM PS_J (Doc ID 2813600.1)

Last updated on OCTOBER 11, 2021

Applies to:

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

Symptoms


When attempting to upgrade from from a lower version to  PT 8.57.20, the following error occurs.

ERROR
-----------------------

Error Position: 12 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: DELETE FROM PS_EOAW_SUMMARY WHERE EOAWPRCS_ID='GLJournalApproval' AND ((EOAWTHREAD_ID NOT IN ( SELECT EOAWTHREAD_ID FROM PS_JRNL_AF_XREF)) OR (EOAWTHREAD_ID IN ( SELECT X.EOAWTHREAD_ID FROM PS_JRNL_AF_XREF X WHERE NOT EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER H WHERE H.BUSINESS_UNIT_IU=X.BUSINESS_UNIT AND H.JOURNAL_ID=X.JOURNAL_ID AND H.JOURNAL_DATE=X.JOURNAL_DATE AND H.BUSINESS_UNIT=X.BUSINESS_UNIT_LN))))
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt857p20b_2101061813-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 12 Return: 942 - ORA-00942: table or view does not exist

The issue can be reproduced at will with the following steps:


1. Install latest PUM
2. Apply it on target
3. Above error encountered at step "Running Data Conversion AE- DCGL23233320 "


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.