GST TDS: New Tax Rate And Tax Category Getting Created By System

(Doc ID 2336898.1)

Last updated on DECEMBER 18, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, GST Payables

ACTUAL BEHAVIOR
---------------
New tax rate and Tax Category getting created automatically for every
invoice.

EXPECTED BEHAVIOR
-----------------------
Should not create new tax rate and tax category for every invoice.

STEPS
-----------------------
The issue can be reproduced at customer instance:
1. Run below query.
select count(*) from JAI_TAX_RATES
check the out put.

2. Create invoice and attach TDS tax category.
3. Validate the invoice.
4. Run below query.
select count(*) from JAI_TAX_RATES
check the out put. New tax rate and tax category added.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users finding duplicate tax categories while attaching tax
category at TDS tax details window.

Changes

The cause of the issue is invalid / incorrect data in jai_tax_rate_details table.
System generating new tax rates and tax categories.

select tax_rate_id from jai_tax_rates where
upper(TAX_RATE_NAME) like upper('%TaxR Trans frm Slb%'))

Cause

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 hundreds of Community platforms