12.0.6 Invoice Validation Fails On ORA-01403 AP_ETAX_SERVICES_PKG

(Doc ID 2163418.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

On : 12.0.6 version, COMCHECK-INVOICES

When attempting to validate the Invoice,
the following error occurs.

ERROR
-----------------------
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORA-01403: no data found occurred in
AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-
with parameters ( P_Invoice_Header_Rec = 2368589 P_Calling_Mode =DISTRIBUTE P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-)
while performing the following operation:
Step 6: Set ref_doc_trx_id if distribution is receipt matched
ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-
with parameters ( P_Invoice_Header_Rec = 2368589 P_Calling_Mode =DISTRIBUTE P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax<-)
while performing the following operation:
Step 6: Set ref_doc_trx_id if distribution is receipt matched
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Cause

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