My Oracle Support Banner

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


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