My Oracle Support Banner

Latin Tax Engine: Credit An Invoice Gets An Unexpected Error Has Occurred. ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated (Doc ID 1593216.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Financials for the Americas - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Latin Tax Engine

Attempting to credit a transaction and receive the following error:

ERROR
-----------------------
An unexpected error has occurred. Please contact your system administrator


Debug Log Shows:

ZX_TDS_CALC_SERVICES_PUB_PKG.set_detail_tax_line_def_val(-)
-1: ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
Incorrect return_status after calling ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt
RETURN_STATUS = U
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
ZX_API_PUB: CALCULATE_TAX:ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors
return status service = U
ARP_ETAX_SERVICES_PKG.Calculate_tax(-)
An unexpected error has occurred. Please contact your system administrator.
No more messages in dequeue.
BEGIN agent(), navigationThreshold(0)
END navigation(FIRST_MESSAGE), threshold(0), messageCount(0), message grouping(FALSE)
arxtwmai_form.arxtwmai(PRE-BLOCK)+
arxtwmai_form.arxtwmai(PRE-BLOCK)-


Steps to Reproduce:
Responsibility:  Receivables with Latin Tax Engine enabled for Colombia
Navigation:  Transactions > Transactions
Query a transaction
Credit the transaction
Error occurs

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
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.