My Oracle Support Banner

R12: AP: Unexpected Error Occurred During Tax Calculation If Tax Details Information Is Edited On Validated Invoice (Doc ID 780683.1)

Last updated on MARCH 20, 2025

Applies to:

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

Symptoms


Invoice Validation fails after changing tax classification code on a validation invoice.

Error:
ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Dist_Marked_For_Delete.END ZX_TRL_MANAGE_TAX_PKG:
DELETE_DIST_MARKED_FOR_DELETE (-)
ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions.BEGIN ZX_TRL_MANAGE_TAX_PKG:
Create_Tax_Distributions (+)
ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions Exception:-1;ORA-00001: unique constraint
(ZX.ZX_REC_NREC_DIST_U3) violated
ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions Return Status = E
ZX.PLSQL.ZX_API_PUB.ADD_MSG.BEGIN ZX_API_PUB: ADD_MSG()+
ZX.PLSQL.ZX_API_PUB.ADD_MSG.END ZX_API_PUB: ADD_MSG()-
ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxDistributions Return Status = U
ZX.PLSQL.ZX_API_PUB.DETERMINE_RECOVERY ZX_API_PUB:
DETERMINE_RECOVERY:ZX_TRL_PUB_PKG.manage_taxdistributions returned errors
AP.PLSQL.AP_ETAX_SERVICES_PKG.Distribute Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages An unexpected error has occurred. Please
contact your system administrator.
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "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."



 
1) Create an invoice with header and more than one item lines
2) Place some control amount on invoice header
3) Validate invoice
4) Override tax on invoice through Tax Details window (Change Tax Rate or amount)
5) Validate the invoice again
     The error occurs.

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!


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