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

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On :Tax Deducted at Source-Payables

ACTUAL BEHAVIOR
---------------
TOTAL_INVOICE_CANCEL_AMOUNT is not getting updated in Threshold group table

EXPECTED BEHAVIOR
-----------------------
TOTAL_INVOICE_CANCEL_AMOUNT should get updated in Threshold group tables

STEPS
-----------------------
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 Credit Memo 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

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

Changes

Cause

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