Normal Threshold Amount Is Getting Updated in Exception Threshold Line in Vendor Threshold Grouping (Doc ID 3039138.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

Amounts in Vendor Threshold Grouping is getting updated incorrectly.
Tax Deducted at Source (TDS) Invoice is generating as per Normal threshold setup, but the total Invoice amount in vendor Threshold Grouping is getting updated in Exception Threshold Line.


STEPS
-----------------------
For example consider the below setup exists for TDS Deduction:

1. Normal Threshold (Cumulative) as:
From Amount: 1
To Amount: Null
Start Date: 27-Jun-24
TDS: 10%

2. Exception Threshold (Cumulative) as:
From Amount: 1
To Amount: 1,37,4238
Start Date : 30-Jun-24
Assign Vendor: Certificate Start Date: 9-May-24
TDS: 1%

3. Go to India Payables Responsibility -> Invoices > Entry > Invoices
Create First Invoice with General Ledger (GL) DATE 02-JUL-2024, Amount: 10,000
Go to Tools -> TDS Tax Details. TDS Defaulted as per Exception Set: 1% ---Correct
Validated and correct TDS Invoice generated.

4. Go to Oracle Financials for India -> Withholding Tax Setup -> Vendor Threshold Grouping
Query for the relevant Vendor Type and Vendor.
Exception Threshold Line Generated in Vendor Threshold Grouping with Amount 10,000.

5. Now Go to India Payables Responsibility -> Invoices > Entry > Invoices.
Create second Invoice with GL Date : 28-Jun-2024, Amount: 25,000
Go to Tools -> TDS Tax Details. TDS defaulted as per Normal Threshold (as per slab dates) : 10% ----Correct
Validated and TDS Invoice generated correctly with 10% rate.

6. Go to Oracle Financials for India -> Withholding Tax Setup -> Vendor Threshold Grouping
Query for the relevant Vendor Type and Vendor.
The amount is updated against the exception threshold Line and Total Amount showing now as 35,000--- Incorrect.

It is expected that this 25000 Amount should be updated in Normal Threshold Line, so that for future Invoices correct TDS calculation should happen.

Cause

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