TDS Invoice Are Not Getting Deducted Post Upgrade To R12.2.X From R12.1.3 (Doc ID 2219342.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version 12.2.4 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Tax Deducted at Source-Payables

ACTUAL BEHAVIOR
---------------
Lower TDS not working post upgrade to R12.2.4.
It was Observed that TDS is not getting deducted post upgrade for an exception threshold setup.
Noticed that a new vendor threshold grouping line has come into being post upgrade causing the issue.

EXPECTED BEHAVIOR
-----------------------
TDS should be deducted post upgrade .

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Below is the actual issue. Numbers / figures are for example purposes only
  Before upgrade to 12.2, the total_invoice_amount for the fin year, vendor_id, pan and org tan number was 2.5 Cr.
  Threshold is cumulative , defined with slabs as 1.5 cr till 5Cr at lower rate.
2. After update , on raising a new invoice for the same vendor , there exists a new record in JAI_AP_TDS_THHOLD_GRPS table
  for the same fin year , vendor_id , pan and org tan number .
  Due to this , if the new invoice amount is 10,000 this is not getting added to the existing already defined 2.5cr.
  Rather it is inserted as a new record.
  Which is why the TDS invoices are not getting generated.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot deduct TDS correctly for the invoice raised after upgrade
making the payment / statutory implications

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