My Oracle Support Banner

R12:AP:ORA-01403: no data found occurred in AP_APPROVAL_PKG.Set_Hold<-AP_APPROVAL_PKG.Process_Inv_Hold_Status<-AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks<-AP_APPROVAL_PKG.Approval<-APXAPRVL (Doc ID 2598821.1)

Last updated on OCTOBER 14, 2019

Applies to:

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

Symptoms

In Oracle Payables, when a user attempts to validate the invoice validation using the invoice workbench form (APXINWKB.fmb) the following error occurs:

ERROR
-------
ORA-01403: no data found occurred in
AP_APPROVAL_PKG.Set_Hold<-AP_APPROVAL_PKG.Process_Inv_Hold_Status<-AP_APPROVAL_MATCHED_PKG.Execute_Matched_Checks<-AP_APPROVAL_PKG.Approval<-APXAPRVL
with parameters (Invoice_id = 15076427, Hold_Code = MAX SHIP AMOUNT, Hold_Reason = )
while performing the following operation

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
References


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