My Oracle Support Banner

R12.0:Approving A Purchase Order Gives Exception: 023 - An Unexpected Error Has Occurred - Tax Calculation (Doc ID 466548.1)

Last updated on JULY 02, 2018

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


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.