My Oracle Support Banner

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

Last updated on MAY 01, 2020

Applies to:

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

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

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
References


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