My Oracle Support Banner

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

Last updated on FEBRUARY 03, 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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.