My Oracle Support Banner

R12: AP: Data Fix ORA-00942: Table Or View Does Not Exist (Doc ID 2487405.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Payables - Version 12.0.0 and later
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)

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


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