Autoinvoice Import Program Is Ending In ERROR: from eBusiness Tax - return code = 2 Exception:-1:ORA-00001: unique constraint (ZX.ZX_LINES_U1) violated (Doc ID 2981153.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When executing the Autoinvoinvoice Master Program for Brazil, the Autoinvoice Import Program is ending in error with the message:

ERROR:
from concurrent request:
ERROR: from eBusiness Tax - return code = 2 Current system time is 19-SEP-2023 21:06:39
Please review the plsql debug log for additional details. Current system time is 19-SEP-2023 21:06:39

from tax debug logfile:
ZX_TRL_MANAGE_TAX_PKG: Create_Detail_Lines (+)
Exception:-1:ORA-00001: unique constraint (ZX.ZX_LINES_U1) violated
Return Status = U
Incorrect return_status after calling ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines()
RETURN_STATUS = U
ZX_TRL_PUB_PKG.Manage_TaxLines(-)
ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_TRL_PUB_PKG.manage_taxlines returned errors

import_document_with_tax returns failure
arp_etax_util.calculate_tax_int()+
ZX_API_PUB.import_document_with_tax returns failure
An unexpected error has occurred. Please contact your system administrator.
An unexpected error has occurred. Please contact your system administrator.
arp_etax_autoinv_util.calculate_tax()-
ERROR: from eBusiness Tax - return code = 2

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation:Concurrent requests -> Autoinvoice

Cause

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