GST Table Changes in Oracle Apps R12

GST Changes in Oracle Apps R12

WHAT IS GST?

Ø  Goods and Services Tax (GST) is an indirect tax throughout India to replace taxes levied by the central and state governments.

When Goods and Services Tax is implemented, there will be 3 kinds of applicable Goods and Services Taxes:

CGST: where the revenue will be collected by the central government

SGST: where the revenue will be collected by the state governments for intra-state sales

IGST: where the revenue will be collected by the central government for inter-state sales

Below is the comparison between New and Old Tax regime

Transaction	New Regime	Old Regime	Comments
Sale within the state	CGST + SGST	VAT + Central Excise/Service tax	Revenue will now be shared between the Centre and the State
Sale to another State	IGST	Central Sales Tax + Excise/Service Tax	There will only be one type of tax (central) now in case of inter-state sales.

The full form of HSN code means Harmonized System Nomenclature.

In India, when implementing GST, all goods are classified based on HSN number for GST purpose. At present, HSN number is mainly used for classifying goods to compute Value Added Tax in India. The same classification code (HSN) is adopted for classifying Goods and Service Tax, GST.

When preparing Tax Invoice for GST, the HSN number must be mentioned on GST invoice.

Oracle has changed its India Localization tax structure and tables to support GST.

A new Responsibility used for defining new tax Rules and assignment of Item to different tax Classifications ‘Oracle Financials for India’ is introduced.

Below are the Forms and tables used in Setup of GST India regime, India Localization party Info and Item HSN Code.

Screen: Define Regime

Table Name: JAI_REGIMES

Define Tax rate in below screen:

Table Name: JAI_TAX_RATES

Define Tax Rules:

Table Name: JAI_TAX_RULES

Define Item Classification.

Table Name: JAI_ITEM_TEMPL_HDR ,  JAI_ITEM_TEMPL_DTLS

Party Registration: First Party Registration

TABLE NAME: JAI_PARTY_REGS

Third Party Registration:

Party Type can be Supplier or Customer based on which party Name LOV will be populated.

Table Name: JAI_PARTY_REGS, JAI_PARTY_REG_LINES

This is some basic information you need to know for GST India implementation in Oracle Apps R12.