My Oracle Support Banner

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 JULY 11, 2018

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

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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