R12: APP-SQLAP-10000 and ORA-6502 Error Messages at Invoice Matching (Doc ID 1616296.1)

Last updated on NOVEMBER 23, 2021

Applies to:

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

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