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
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 |