AP Invoice Validation Concurrent Request Failure: ORA-01403: no data found occurred in AP_FUNDS_CONTROL_PKG.Calc_QV ... while performing the following operation: CALC_QV - find dist line with max qty for positive qty_variance (Doc ID 1913700.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

The reported error occurs in EBS application version 12.1.3 and pertains to the AP invoice validation process:

An invoice fails validation with error CALC_QV - find dist line with max qty for positive qty_variance

Here is the detailed message as per the Invoice Validation concurrent request log (IDs removed and replaced with generic parameter values):

Error message
ORA-01403: no data found occurred in
AP_FUNDS_CONTROL_PKG.Calc_QV<-AP_APPROVAL_MATCHED_PKG.Exec_Qty_Variance_Check<-AP_APPROVAL_PKG.Approval<-APXAPRVL
with parameters (Invoice_id = &invoice_Id, Po_dist_id = &PO_dist_id, Inv_currency_code = &invoice_currency_code, Po_price = &po_price, Po_qty = &po_qty)
while performing the following operation:
CALC_QV - find dist line with max qty for positive qty_variance
ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_FUNDS_CONTROL_PKG.Calc_QV<-AP_APPROVAL_MATCHED_PKG.Exec_Qty_Variance_Check<-AP_APPROVAL_PKG.Approval<-APXAPRVL
with parameters (Invoice_id = &invoice_Id, Po_dist_id = &PO_dist_id, Inv_currency_code = &invoice_currency_code, Po_price = &po_price, Po_qty = &po_qty)
while performing the following operation:
CALC_QV - find dist line with max qty for positive qty_variance

Step to reproduce / scenario
Actions > Online validation
or
Run the 'Invoice Validation' concurrent progrma.

The invoice is one of many matched to a Purchase Order.
Each invoice needs to be put on a qty order/receipt hold.
Then invoice validation is executed.
One of the invoices validates, but not this one; it fails as per the error above.

Workaround
Re-run the validation.

Business impact
Functional: Requires multiple runs of invoice validation to get the invoice processed. Not efficient.

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