My Oracle Support Banner

R12 _GST: Error when calculating tax ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines Exception:-1:ORA-00001: unique constraint (ZX.ZX_LINES_U1) violated (Doc ID 2302432.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, GST

The client made a setup in ebtax to solve the India GST requirements
they created a unique offset taxe used for all type of India GST tax : CGST, IGST & SGST

When attempting to calculate tax (
the following error occurs.

ERROR
-----------------------
Could not update the Payables information for the modification done in Tax window due to : An Unexpected error has occurred.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. calculate tax for one invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot calculate offset tax invoices

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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