TDS: ORA-00001: unique constraint (JA.JAI_AP_TDS_DEFAULT_U1) violated in TDS Tax Details (Duplicate Adhoc Tax Lines) (Doc ID 2465977.1)

Last updated on JANUARY 17, 2023

Applies to:

Symptoms

On : 12.1.3 version, TDS

When attempting to validate the invoice
the following error occurs.

ERROR
-----------------------
ORA-00001: unique constraint (JA.JAI_AP_TDS_DEFAULT_U1) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Scenario : When an invoice is created from PO and receipt with adhoc taxes/manually created.
In TDS tax details, the Adhoc Tax line appears twice and on validation, TDS is not deducted and TDS invoice is not generated. 
If TDS tax category is applied only for one of the Adhoc lines, then also TDS category gets assigned to both lines and finally TDS is not deducted.

1. Create a PO with taxes - gst and adhoc
2. Create a Receipt for the PO
3. Create an Invoice for the receipt where the gst taxes and adhoc taxes are
copied
4. In TDS Tax Details, duplicate lines appear for the Adhoc tax line
5. TDS tax category applied for one line but on saving gets applied for both
lines
6. On invoice validation, no TDS is deducted and following error message is
encountered in TDS Tax Details:
ORA-00001 : unique constraint (JA.JAI_AP_TDS_DEFAULT_UI) violated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate TDS and results in compliance issues

Changes

Cause

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