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 APRIL 04, 2025

Applies to:

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

Symptoms

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

Error:

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:

ZX_ON_FLY_TRX_UPGRADE_PO_PKG.upgrade_trx_on_fly_po(-)
x_return_status:
ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(-)
"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
RETURN_STATUS = U
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.