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 DECEMBER 14, 2017

Applies to:

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

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms