My Oracle Support Banner

R12: AP: Validating an Invoice Errors With APP-SQLAP-10000: ORA-01403 : no data found occurred in AP_ETAX_UTILITY_PKG.Return_tax_Distributions (Doc ID 1555062.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle E-Business Tax - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to validate the invoice, the following error occurs:

APP-SQLAP-10000: ORA-01403: no data found occurred in AP_ETAX_UTILITY_PKG while validation of invoice.

AP.PLSQL.AP_ETAX_UTILITY_PKG.RETURN_TAX_DISTRIBUTIONS
ORA-01403: no data found



The FND Debug Log of the process shows:

 

fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 
"APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP<-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-AP_APPROVAL_PKG.Approval<-APXINWKB
with parameters ( P_Invoice_I"

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.