R12: AP: Undo Accounting Error: 'in side AP_Acctg_Data_Fix_PKG.Backup_data <- Complete Undo Acctg of invoices' OR '-6502-ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Complete Undo Acctg'
(Doc ID 2778044.1)
Last updated on APRIL 29, 2022
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run Undo Accounting script ap_undo_cmplt_inv.sql next situation might occur:
1)
Exception :: ORA-00922: missing or invalid option
in side AP_Acctg_Data_Fix_PKG.Backup_data <- Complete Undo Acctg of invoices
OR
2)
-6502-ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Complete Undo Acctg of invoices while performing Calling bkp_acctg for backing Accounting Journals for Invoice
OR
3)
NO Errors after running Undo script, but it is just not processing the invoice, and
AP_UNDO_EVENT_LOG has no rows selected, and
The value in ap_undo_invoices.process_flag remains 'Y'.
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 |