GST : TDS invoices are not generated upon validation of payables invoice with relevant TDS taxes (Doc ID 2665662.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Reported Issue
----------------
Though TDS is applied or defaulted on the payables (AP) invoice, find that on validation of that invoice,
the relevant TDS invoices are not getting generated.

Steps for replication
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables.
2. Path: Invoices -> Entry -> Invoices.
3. Validate the invoice.
4. In tools - TDS tax details form , the tax amount doesn't gets calculated even though the 
    tax rate, section code and tax category defaults from third party information defined for the vendor.

Error message ( from fnd debug log )
------------------
JAI.PLSQL.JAI_AP_DTC_DEFAULTATION_PKG.DEFAULT_TDS_FROM_SETUP.exception Error from default_tds_from_setup :ORA-00001: unique constraint (JA.JAI_AP_WTHINV_TAX_U1) violated
JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG..process_dtc_at_inv_validate() 21 Process flag E
JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG..process_dtc_at_inv_validate() 21 Process message Error from default_tds_from_setup :ORA-00001: unique constraint (JA.JAI_AP_WTHINV_TAX_U1) violated
JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG.process_dtc_at_inv_validate().END JAI_AP_DTC_GENERATION_PKG: process_dtc_at_inv_validate()()-
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : Error from default_tds_from_setup :ORA-00001: unique constraint (JA.JAI_AP_WTHINV_TAX_U1) violated


Business Impact 
-------------------
The issue has the following business impact:
Due to this issue, users cannot calculate tax.

Cause

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