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 JUNE 21, 2023

Applies to:

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

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