R12: APP-SQLAP-10000 and ORA-6502 Error Messages at Invoice Matching
(Doc ID 1616296.1)
Last updated on APRIL 03, 2025
Applies to:
Oracle Payables - Version 12.0.1 and laterInformation in this document applies to any platform.
APXINWKB - Invoices Entry form
APXPMTCH - Purchase Order Matching form
APXRMTCH - Receipts Matching form
Symptoms
Trying to match an Invoice to a PO or to a Receipt, APP-SQLAP-10000 and ORA-06502 error messages arise, as follows:
APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value occurred in:
Get_Shipment_List_For_QuickMatchInv_Sum_Folder_Quick_Match.Event with parameters
(invoice_id = XX, Po header id = XX, match option = p, match_amount = XX)
while performing the following operation: Fetch next record of PO_Shipment_List_Cursor
or
APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in
AP_MATCHING_UTILS_PKG.IS_PROJ_EXP_ITEM_DATE_VALID
or
APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in
GET_info<-AP_MATCHING_PKG.base_credit_po_match<-APXPMTCH with parameters(Invoice iD = ...)
while performing the following operation:
or
APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APPS.AP_RECT_MATCH_PKG", line 3255
ORA-06502: PL/SQL: numeric or value error occurred in AP_MATCHING_PKG.base_credit_rcv_match
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 |