R12: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 JUNE 12, 2024
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
Below is the detailed message as per the Invoice Validation concurrent request log (IDs removed and replaced with generic parameter values):
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 program.
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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |