R12: APP-SQLAP-10000 and ORA-6502 Error Messages at Invoice Matching

(Doc ID 1616296.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
APXINWKB - Invoices Entry form
APXPMTCH - Purchase Order Matching form
APXRMTCH - Receipts Matching form

Symptoms

OA release 12 - Invoice Matching

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms