My Oracle Support Banner

GST TDS: New Tax Rate And Tax Category Getting Created By System (Doc ID 2336898.1)

Last updated on MAY 10, 2018

Applies to:

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


On : 12.1.3 version, GST Payables

New tax rate and Tax Category getting created automatically for every

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

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.

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.


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%'))


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.