E-Business Tax Issue: Attempt to Create Orders, Using OE_ORDER_PUB.process_order API and it Errors with Unique Constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) Violated

(Doc ID 1684032.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

Attempting to create a sales order, using OE_ORDER_PUB.process_order API and receive the following error:

ERROR
-----------------------
Exiting OM_TAX_UTIL.Debug_msg procedure
tax_line 11
Message returned by tax API ZX_API_PUB.calculate_tax: 1
An unexpected error has occurred. Please contact your system administrator.
LEAVING OE_MSG_PUB.ADD
tax engine call returned unexp error
ENTER SET RECURSION MODE

The Tax Debug Log has the following error:

ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt -1:
ORA-1: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated

Cause

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 hundreds of Community platforms