GST : Duplicate Records In Threshold Grouping For Vendor , Fin Year, Section Code,Tan Number Due To Which TDS Is Not Considering Previous Threshold Setup (Doc ID 2295289.1)

Last updated on JULY 19, 2020

Applies to:

Symptoms

On :  12.1.1 version, GST Payables

ACTUAL BEHAVIOR  
---------------
On raising Invoice on GST architecture observed TDS is not getting generated.
In short, system is NOT honoring previous Cumulative Threshold Slabs which were defined Pre-GST.
On further review , observed that this is observed because there are duplicate records in Vendor threshold Grouping i.e. JAI_AP_TDS_THHOLD_GRPS
For "Vendor", "Org Tan Num", "Section Code","Fin Year" ,"Vendor PAN " there are two records i.e.
a. For Older Cumulative Threshold pre-GST
b. For New Invoice Created under the same Threshold , Post- GST

EXPECTED BEHAVIOR
-----------------------
Since the Cumulative Threshold setup is valid , TDS invoices are to be generated honoring the setup.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a. Raise a AP invoice
b. Apply TDS taxes
c. On validation , related TDS invoices are not generated.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot generate TDS invoices and payments to suppliers are impacted.

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.