My Oracle Support Banner

R12:AP: EBTax:Validate Invoice "Unexpected Error Occurred During Tax Calculation","An Error Occurred In POP_ESTB_ID","ORA-01403 No Data Found" (Doc ID 1354530.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.


When attempting to calculate tax or validate an invoice errors with:

Unexpected error occurred during Tax Calculation.
Exception: An unexpected error has occurred. Please
contact your system administrator.
Please correct the problem or contact your system administrator.

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables
2. Path: Invoices -> Enter -> Invoices
3. Create an invoice and save.
4. Validate the invoice and error occurs.

Debug tax log file is showing :

ZX_SRVC_TYP_PKG: Pop_Estb_Id()+
Error occurred in POP_ESTB_ID : ORA-01403: no data found
User-Defined Exception
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
0 Error Message(s) dumped into Zx_Errors_GT.
Handle errors returned by API
Get error message from eTax API
Get error message from stack
An unexpected error has occurred. Please contact your system administrator.




To view full details, 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 a vibrant support community of peers and Oracle experts.