R12: Invoice Validation Error APP-SQLAP-10000: ORA-01403: No Data Found Occurred in AP_FUNDS_CONTROL_PKG

(Doc ID 1951356.1)

Last updated on APRIL 07, 2015

Applies to:

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


While validating invoice which is in 'Needs Revalidation' and it is matched with an amount base Purchase Order ( PO ) and PO is overbilled with multiple invoices, the following error occurs:


APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_FUNDS_CONTROL_PKG.Calc_AV<-AP_APPROVAL_MATCHED_PKG.Exec_Amt_Variance_Check<-AP_APPROVAL_PKG.Approval with parameters (Invoice_id = XXXX, Po_dist_id = YYYY, Inv_currency_code = TTTT, Po_amt = ZZZZ )
while performing the following operation:
CALC_AV - find dist line with max amt for positive amt_variance

The issue can be reproduced at will with the following steps:
1. Navigate to Payables responsibility
2. Go to Invoices > Entry > Invoices
3. Query for the invoice
4. Click on the "Actions" button and choose to Validate the invoice

The issue has the following business impact:
Due to this issue, users cannot account and pay the invoice.


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