My Oracle Support Banner

R12: AP:When Matching an Invoice an Error is Returned: ORA-01403: no data found occurred in AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks<-AP_APPROVAL_PKG.Approval (Doc ID 2960506.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

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

Symptoms

In Oracle Payables, after match  an invoice  with the purchase order and trying to run the validation process on the invoice, the application returns an error.

Error:

ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks<-AP_APPROVAL_PKG.Approval<-APXAPRVL
with parameters (Invoice_id  = &p_inv_id, Dist_line_num = XX, Packet_id = XX, Fundscheck mode = XX, Partial_reserv_flag = , Max QTY REC Tol = )
while performing the following operation:
Get receipt quantites for &P_RCV_TRX

 

Steps

1. Navigate to Payables Responsibility
2 Query an invoice that is matched to a PO (Purchase order)
3 Goto  (B)Actions...1
4 Select  Validate
5 Error is returned and invoice cannot be validated.

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


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