R12: AP: Data Fix ORA-00942: Table Or View Does Not Exist
(Doc ID 2487405.1)
Last updated on AUGUST 11, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle E-Business Tax - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.
Symptoms
When execute the fix script (ap_cancel_inv_fix.sql) based on the data fix note 1060611.1, encounter the errors as below:
Replace this with note box text.
before undo accounting invoices
Created table AP_INV_UNDO_TBL_9088967
Calling AP_ACCTG_DATA_FIX_PKG.Undo_Acctg_Entries
Could not find the column event_id in the driver table AP_INV_UNDO_TBL_9088967 : aborting
======== Back from AP_ACCTG_DATA_FIX_PKG.Undo_Acctg_Entries for Invoice undo ========
======== Updated process_flag = 'D' for 1 records in AP_TEMP_DATA_DRIVER_9088967 table after invoice undo accounting========
======== Updated process_flag = 'E' for 0 records in AP_TEMP_DATA_DRIVER_9088967 table after invoice undo accounting========
before backing up data
Exception :: ORA-00942: table or view does not exist
in side AP_Acctg_Data_Fix_PKG.Backup_data <- Generic Data Fix Script (ap_cancel_inv_fix.sql)
before undo accounting invoices
Created table AP_INV_UNDO_TBL_9088967
Calling AP_ACCTG_DATA_FIX_PKG.Undo_Acctg_Entries
Could not find the column event_id in the driver table AP_INV_UNDO_TBL_9088967 : aborting
======== Back from AP_ACCTG_DATA_FIX_PKG.Undo_Acctg_Entries for Invoice undo ========
======== Updated process_flag = 'D' for 1 records in AP_TEMP_DATA_DRIVER_9088967 table after invoice undo accounting========
======== Updated process_flag = 'E' for 0 records in AP_TEMP_DATA_DRIVER_9088967 table after invoice undo accounting========
before backing up data
Exception :: ORA-00942: table or view does not exist
in side AP_Acctg_Data_Fix_PKG.Backup_data <- Generic Data Fix Script (ap_cancel_inv_fix.sql)
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 |
| Cause |
| Solution |
| References |