R12: Etax: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 MAY 24, 2017

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.

Symptoms


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.
The following error occurs:

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.

5. Debug tax log file

ZX_SRVC_TYP_PKG: Pop_Estb_Id()+
Error occurred in POP_ESTB_ID : ORA-01403: no data found
RETURN_STATUS = U
User-Defined Exception
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
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.

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