R12.0:Approving A Purchase Order Gives Exception: 023 - An Unexpected Error Has Occurred - Tax Calculation

(Doc ID 466548.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Purchasing - Version 12.0.2 to 12.0.6 [Release 12]
Information in this document applies to any platform.


On R12, the following unexpected error occurred during Tax Calculation.


Exception: 023 - An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator.

The FND Log  shows the following error:

"Data is expected to be in eBTax repository for this call. Please CHECK your
sequence of calls to eBTaxORA-01403: no data found
ORA-01403: no data found"
determine_recovery returned with status U
Start of subprogram.
p_error_level is null

Another example of the error seen in the FND Debug Logging:

ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors


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