My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

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.


On : 12.2.4 version, Tax Deducted at Source-Payables

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.

TDS should be deducted post upgrade .

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.

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




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

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