My Oracle Support Banner

TDS Threshold not updated for Cancelled Invoice (Doc ID 2411679.1)

Last updated on JUNE 15, 2018

Applies to:

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


On :Tax Deducted at Source-Payables

TOTAL_INVOICE_CANCEL_AMOUNT is not getting updated in Threshold group table

TOTAL_INVOICE_CANCEL_AMOUNT should get updated in Threshold group tables

The issue can be reproduced at will with the following steps:
1. Create a Invoice with "X" amount such that it doesn't cross thresholds
2. Validate the same
3. TDS and CM doesn't created which is fine as threshold is not crossed
4. Check the JAI_AP_TDS_THHOLD_GRPS .We can see that TOTAL_INVOICE_AMOUNT column is updated
5. Cancel the Invoice
6. Invoice gets canceled but the TOTAL_INVOICE_CANCEL_AMOUNT column is not updated in JAI_AP_TDS_THHOLD_GRPS

The issue has the following business impact:
Due to this issue, vendor threshold amount is showing on higher side which is incorrect




To view full details, 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 a vibrant support community of peers and Oracle experts.