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 DECEMBER 10, 2024
Applies to:
Oracle Financials for the Americas - Version 12.1.2 and laterInformation 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 |