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.

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 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

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

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.