My Oracle Support Banner

GST: TDS Not Generated As Wrong Amount Calculated In JAI_AP_TDS_THHOLD_GRPS For Foreign Currency (Doc ID 2525633.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, Tax Deducted at Source-Payables

ACTUAL BEHAVIOR
---------------
TDS invoice not getting generated. Invoice amount is getting multiplied with currency conversion rate in JAI_AP_TDS_THHOLD_GRPS table. The amount with which currency is multiplied is picked up from jai_ap_wthld_inv_taxes table which has amount in INR only. Resulting in wrong amount being updated in JAI_AP_TDS_THHOLD_GRPS and vendor threshold grouping screen and TDS amount getting breached.

EXPECTED BEHAVIOR
-----------------------
TDS should get generated as per setup and correct amount should get calculated in JAI_AP_TDS_THHOLD_GRPS

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate TDS, resulting in pending of payment to authority.

Changes

Invoice apply amount showing correct at threshold grouping window

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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