My Oracle Support Banner

R12:AP: Payables Open Interface Import Errors Out With APP-SQLAP-4667613: Matching could not be completed due to application error while synchronizing quantity and amount billed on PO (Doc ID 2554758.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms



When attempting to import invoices using Payables Open Interface Import program, fails with the following error:

Error in FND debug log 

APP-SQLAP-4667613: Matching could not be completed due to application error while synchronizing quantity and amount billed on PO. Try again.
Error detail: User-Defined Exception inside Update_Po_Shipments_Dists<-AP_PO_AMT_MATCH_PKG.ap_amt_match<-AP_MATCHING_UTILS_PKG.Match_Invoice_Line <-Create_lines<-Import_invoiceswith parameters (PO Line location Id = XXXXX, UOM= Each) while performing operation: POXAPINB.pls-ORA-06533: Subscript beyond count: Subroutine update_document_ap_values returned error

Cause: Subroutine update_document_ap_values returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system administrator for assistance.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Populate interface tables..
2. Navigate in Payables Manager > Other > Request > Run
3. Chose program Payables Open Interface Import
4. See the error in the log file

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


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