Oracle EBS GST-First Party Reg.

Oracle EBS GST-First Party Reg
Configuration:First Party,
Responsibility:Oracle Financials For India,
Navigation:Party Registration->Define First Party Registration

Tables:-
JAI_PARTY_REGS
JAI_PARTY_REG_LINES
JAI_REGIMES
JAI_PARTY_REG_LINES_V
jai_tax_other_rounding_v
jai_reporting_associations

Example:-

SELECT 
jprv.PARTY_CLASS_NAME "Regime Type"
,decode(jpr.PARTY_TYPE_CODE,'IO','Inventory Organization') "Organization Type"
,jprv.PARTY_NAME  "Organization Name"
,jprv.PARTY_SITE_NAME "Loaction Name"
,jpr.ORG_CLASSIFICATION_CODE  "Organization Activity"
,jprv.PARTY_SITE_ADDRESS  "Address"
,jr.REGIME_NAME "Regime Code"
,jprlv.REGISTRATION_TYPE_NAME "Primary Registration Name"
,jprl.REGISTRATION_NUMBER  "Primary Registration Number"
,jprlv.SEC_REGISTRATION_TYPE_NAME "Secondary Registration Name"
,jprl.SECONDARY_REGISTRATION_NUMBER  "Secondary Registration Number"
,jprlv.TAX_AUTHORITY_NAME "Tax Authority"
,jprlv.TAX_AUTHORITY_SITE_NAME  "Tax Authority Site"
,gcck.CONCATENATED_SEGMENTS "Intercompany Payable"
,gcck1.CONCATENATED_SEGMENTS "Intercompany Receivable"
,jprl.EFFECTIVE_FROM  "Start Date"
,jprl.EFFECTIVE_TO  "End Date"
,jtorv.REGIME_CODE "R-Regime Code"
,jtorv.ROUNDING_BASIS_DESC  "Rounding Basis"
,jtorv.ROUNDED_TO_DESC  "Round To"
,jtorv.ROUNDED_FACTOR_DESC  "Rounded Factor"
,jtorv.EFFECTIVE_FROM "R-Start Date"
,jtorv.EFFECTIVE_TO "R-End Date"
,jra.REPORTING_TYPE_NAME  "Reporting Type Name"
,jra.REPORTING_CODE "Reporting Code"
,jra.REPORTING_CODE_DESCRIPTION "Reporting Code Description"
,jra.EFFECTIVE_FROM "Reporting Start Date"
,jra.EFFECTIVE_TO "Reporting End Date"
FROM
APPS.JAI_PARTY_REGS jpr,
APPS.JAI_PARTY_REGS_V  jprv,
APPS.org_organization_definitions  ood,
APPS.hr_organization_units hou,
APPS.hr_operating_units  hou1,
APPS.hr_locations_all  hla,
APPS.JAI_PARTY_REG_LINES jprl,
APPS.JAI_REGIMES jr,
APPS.JAI_PARTY_REG_LINES_V jprlv,
APPS.GL_CODE_COMBINATIONS_KFV gcck,
APPS.GL_CODE_COMBINATIONS_KFV gcck1,
APPS.jai_tax_other_rounding_v  jtorv,
APPS.jai_reporting_associations  jra
WHERE 1=1
AND jpr.PARTY_REG_ID=jprv.PARTY_REG_ID
AND jpr.PARTY_TYPE_CODE=jprv.PARTY_TYPE_CODE
AND jpr.PARTY_ID=jprv.PARTY_ID
AND jpr.PARTY_SITE_ID=jprv.PARTY_SITE_ID
AND jprv.PARTY_CLASS_NAME='Transaction Tax'
AND jprv.ORG_ID=hou1.ORGANIZATION_ID
AND jpr.org_id=ood.OPERATING_UNIT
AND ood.ORGANIZATION_ID=hou.ORGANIZATION_ID
AND hou.LOCATION_ID=hla.LOCATION_ID
AND jpr.PARTY_REG_ID=jprl.PARTY_REG_ID
AND jprl.REGIME_ID=jr.REGIME_ID
AND jr.REGIME_TYPE='T'
AND jprl.PARTY_REG_ID=jprlv.PARTY_REG_ID
AND jprl.PARTY_REG_LINE_ID=jprlv.PARTY_REG_LINE_ID
AND jprl.INTERCOMPANY_PAYABLE_CCID=gcck.CODE_COMBINATION_ID
AND jprl.INTERCOMPANY_RECEIVABLE_CCID=gcck1.CODE_COMBINATION_ID
AND jr.REGIME_ID=jtorv.REGIME_ID(+)
AND jprv.PARTY_REG_ID=jra.REPORTING_ASSOCIATION_ID
AND hou1.name= '&&';

Oracle EBS GST-AP Payables Options

Oracle EBS GST-AP Payables Options
Configuration:AP-Payables Options,
Responsibility:Oracle Payables,
Navigation:Setup ->Options ->Payables Options

Tables:-
AP_SYSTEM_PARAMETERS_ALL
gl_daily_conversion_types 
HR_OPERATING_UNITS
GL_CODE_COMBINATIONS_KFV
AP_TERMS_TL 
AP_TOLERANCES 
AP_EXPENSE_REPORTS
AP_AWT_GROUPS

Example:-

SELECT DISTINCT
hou.name
,aspa.when_to_account_pmt
,aspa.recon_accounting_flag
,aspa.when_to_account_gain_loss
,aspa.recon_accounting_flag
,aspa.future_dated_pmt_acct_source
,aspa.liability_post_lookup_code
,aspa.discount_distribution_method
,aspa.prorate_int_inv_across_dists
,aspa.build_prepayment_accounts_flag
,aspa.multi_currency_flag
,aspa.make_rate_mandatory_flag
,aspa.calc_user_xrate
,gdc.USER_CONVERSION_TYPE
,gcck.concatenated_segments
,gcck2.concatenated_segments
,gcck3.concatenated_segments
,aspa.combined_filing_flag
,aspa.income_tax_region_flag
,aspa.income_tax_region
,aspa.confirm_date_as_inv_num_flag
,aspa.approvals_option
,aspa.inv_doc_category_override
,aspa.allow_paid_invoice_adjust
,aspa.recalc_pay_schedule_flag
,aspa.allow_supplier_bank_override
,aspa.allow_inv_third_party_ovrd
,aspa.receipt_acceptance_days
,aspa.gl_date_from_receipt_flag
,gcck4.concatenated_segments
,att.name
,aspa.add_days_settlement_date
,gcck5.concatenated_segments
,aspa.approval_workflow_flag
,aspa.allow_force_approval_flag
,aspa.validate_before_approval_flag
,aspa.approval_timing
,aspa.allow_final_match_flag
,aspa.allow_dist_match_flag
,aspa.allow_flex_override_flag
,aspa.transfer_desc_flex_flag
,at.tolerance_name
,at2.tolerance_name
,aspa.auto_calculate_interest_flag
,aspa.interest_tolerance_amount
,gcck6.concatenated_segments
,gcck7.concatenated_segments
,aer.report_type
,aspa.apply_advances_default
,aspa.create_employee_vendor_flag
,att2.name
,aspa.employee_pay_group_lookup_code
,aspa.employee_payment_priority
,aspa.hold_unmatched_invoices_flag
,aspa.disc_is_inv_less_tax_flag
,aspa.post_dated_payments_flag
,aspa.replace_check_flag
,aspa.update_pay_site_flag
,aspa.use_bank_charge_flag
,aspa.bank_charge_bearer
,aspa.allow_pymt_third_party_ovrd
,aspa.pay_doc_category_override
,aspa.allow_awt_flag
,aspa.allow_awt_override
,aag.name
,aspa.awt_include_discount_amt
,aspa.awt_include_tax_amt
,aspa.create_awt_dists_type
,aspa.create_awt_invoices_type
,aspa.withholding_date_basis
,aspa.enable_1099_on_awt_flag
,aspa.invoice_currency_code
,aspa.vendor_pay_group_lookup_code
,aspa.terms_date_basis
,aspa.pay_date_basis_lookup_code
,att2.name,aspa.sort_by_alternate_field
 FROM
 APPS.AP_SYSTEM_PARAMETERS_ALL ASPA 
,APPS.gl_daily_conversion_types gdc 
,APPS.HR_OPERATING_UNITS HOU 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK2 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK3 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK4 
,APPS.AP_TERMS_TL ATT 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK5 
,APPS.AP_TOLERANCES AT 
,APPS.AP_TOLERANCES AT2 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK6 
,APPS.GL_CODE_COMBINATIONS_KFV GCCK7 
,APPS.AP_EXPENSE_REPORTS AER 
,APPS.AP_TERMS_TL ATT2 
,APPS.AP_AWT_GROUPS AAG 
WHERE 1=1
AND aspa.org_id=hou.organization_id 
AND aspa.default_exchange_rate_type=gdc.CONVERSION_TYPE(+) 
AND aspa.gain_code_combination_id=gcck.code_combination_id(+) 
AND aspa.loss_code_combination_id=gcck2.code_combination_id (+)
AND aspa.rounding_error_ccid=gcck3.code_combination_id (+)
AND aspa.freight_code_combination_id=gcck4.code_combination_id(+) 
AND att.term_id(+)=aspa.prepayment_terms_id 
AND aspa.prepay_tax_diff_ccid=gcck5.code_combination_id(+) 
AND aspa.tolerance_id=at.tolerance_id(+) 
AND aspa.services_tolerance_id=at2.tolerance_id(+) 
AND aspa.interest_code_combination_id=gcck6.code_combination_id(+) 
AND aer.expense_report_id(+)=aspa.expense_report_id 
AND aspa.interest_accts_pay_ccid=gcck7.code_combination_id(+) 
AND att2.term_id(+)=aspa.terms_id 
AND aag.group_id(+)=aspa.default_awt_group_id 
AND hou.name= '&&';

Oracle EBS GST-Tax Conversion

Oracle EBS GST-Tax Conversion
Configuration:Tax Conversion,
Responsibility:Oracle Financials For India,
Navigation:Tax Configuration ->Define Tax Conversion

Tables:-
JAI_IM_TAX_MAPPING

Example:-

SELECT DISTINCT
hou.NAME  "Opearting Unit"
,jitm.TAXABLE_EVENT "Taxable Event"
,decode(jitm.USE_EBS_TAX,'Y','Yes') "Use EBS Tax Rate"
,NULL AS "Imported Tax Rate Name"
,NULL AS  "OFI Tax Rate Name"
,NULL AS  "Inclusive Flag"
FROM
APPS.JAI_IM_TAX_MAPPING jitm,
APPS.hr_operating_units  hou
WHERE 1=1
AND jitm.ORG_ID=hou.ORGANIZATION_ID
AND hou.name= '&&';

Oracle EBS GST-Tax Category

Oracle EBS GST-Tax Category
Configuration:Tax Category,
Responsibility:Oracle Financials For India,
Navigation:Tax Configuration ->Define Tax categories

Tables:-
JAI_TAX_CATEGORIES
jai_tax_category_lines
JAI_TAX_RATES
JAI_REGIMES
JAI_TAX_TYPES
jai_tax_category_lines_v

Example:-

SELECT DISTINCT
hou.name  "Opearting Unit"
,jtc.TAX_CATEGORY_NAME  "Tax Category"
,jtc.TAX_CATEGORY_DESC  "Description"
,jtc.ITEM_CLASS_CODE  "Item Class"
,jtc.ITEM_CLASS_CODE  "Item Class Code"
,jtc.EFFECTIVE_FROM "Start Date"
,jtc.EFFECTIVE_TO "End Date"
,jtcl.LINE_NUMBER "Num"
,jtr.TAX_RATE_NAME  "Tax Rate"
,jr.REGIME_CODE "Regime Code"
,jtt.TAX_TYPE_NAME  "Tax Type"
,jtcl.PRECEDENCE_1  "1"
,jtcl.PRECEDENCE_2  "2"
,jtcl.PRECEDENCE_3  "3"
,jtcl.PRECEDENCE_4  "4"
,jtcl.PRECEDENCE_5  "5"
,jtcl.PRECEDENCE_6  "6"
,jtcl.PRECEDENCE_7  "7"
,jtcl.PRECEDENCE_8  "8"
,jtcl.PRECEDENCE_9  "9"
,jtcl.PRECEDENCE_10  "10"
,jtcl.PRECEDENCE_11  "11"
,jtcl.PRECEDENCE_12  "12"
,jtcl.PRECEDENCE_13  "13"
,jtcl.PRECEDENCE_14  "14"
,jtcl.PRECEDENCE_15  "15"
,jtcl.PRECEDENCE_16  "16"
,jtcl.PRECEDENCE_17  "17"
,jtcl.PRECEDENCE_18  "18"
,jtcl.PRECEDENCE_19  "19"
,jtcl.PRECEDENCE_20  "20"
,jtclv.RECOVERABLE_FLAG "Recoverable"
,jtclv.INCLUSIVE_FLAG  "Inclusive"
,jtclv.SELF_ASSESSED_FLAG "Self Assessed"
FROM
APPS.JAI_TAX_CATEGORIES jtc,
APPS.hr_operating_units  hou,
APPS.jai_tax_category_lines  jtcl,
APPS.JAI_TAX_RATES jtr,
APPS.JAI_REGIMES jr,
APPS.JAI_TAX_TYPES  jtt,
APPS.jai_tax_category_lines_v  jtclv
WHERE 1=1
AND jtc.ORG_ID=hou.ORGANIZATION_ID
AND jtc.ORG_ID=jtr.ORG_ID
AND jtc.TAX_CATEGORY_ID=jtcl.TAX_CATEGORY_ID
AND jtcl.TAX_RATE_ID=jtr.TAX_RATE_ID
AND jtcl.REGIME_ID=jr.REGIME_ID
AND jtcl.TAX_TYPE_ID=jtt.TAX_TYPE_ID
AND jtcl.REGIME_ID=jtt.REGIME_ID
AND jtcl.TAX_CATEGORY_LINE_ID=jtclv.TAX_CATEGORY_LINE_ID
AND jtcl.TAX_CATEGORY_ID=jtclv.TAX_CATEGORY_ID
AND hou.name= '&&';

Oracle EBS GST-Tax Type

Oracle EBS GST-Tax Type
Configuration:Tax Type,
Responsibility:Oracle Financials For India,
Navigation:Tax Configuration ->Define Tax Type

Tables:-
JAI_REGIMES
JAI_TAX_TYPES
jai_tax_accounts
jai_reporting_associations

SELECT DISTINCT
jr.REGIME_CODE "Tax Regime Code"
,jr.REGIME_NAME  "Tax Regime Name"
,jtt.TAX_TYPE_CODE  "Tax Type Code"
,jtt.TAX_TYPE_NAME  "Tax Type"
,jtt.EFFECTIVE_FROM "Start Date"
,jtt.EFFECTIVE_TO "End Date"
,jtt.RECOVERABLE_FLAG "Recoverable tax"
,jtt.ALLOW_ABATEMENT "Allow abatement"
,jtt.OFFSET_FLAG  "Applicable for offset"
,jtt.SELF_ASSESSED_FLAG "Self asses./reverse charge"
,jtt.REPORTING_ONLY_FLAG  "Set tax type for reporting"
,jtt.UPDATE_VENDOR_ON_TRANSACTION "Update vendor on trans"
,jtt.WTHLD_TRX_APPLICABLE_FLAG  "WHT Tax applicable"
,jtt.TAX_POINT_BASIS  "Tax Point Basis"
,gsob.NAME  "Ledger"
,hou.name "Operating Unit"
,ood.ORGANIZATION_NAME  "Inventory Organization"
,hla.DESCRIPTION  "Location"
,gcck.CONCATENATED_SEGMENTS "Interim Recovery"
,gcck.CONCATENATED_SEGMENTS "Recovery"
,gcck1.CONCATENATED_SEGMENTS "Interim Liability"
,gcck1.CONCATENATED_SEGMENTS "Liability"
,gcck2.CONCATENATED_SEGMENTS "Expense"
,gcck3.CONCATENATED_SEGMENTS "Rounding Account"
,gcck4.CONCATENATED_SEGMENTS "Suspense Account"
,gcck5.CONCATENATED_SEGMENTS "Advanced Suspense"
,jra.REPORTING_TYPE_NAME  "Reporting Type Name"
,jra.REPORTING_CODE "Reporting Code"
,jra.REPORTING_CODE_DESCRIPTION "Reporting Code Description"
,jra.EFFECTIVE_FROM "Reporting Start Date"
,jra.EFFECTIVE_TO "Reporting End Date"
FROM
APPS.JAI_REGIMES jr,
APPS.JAI_TAX_TYPES  jtt,
APPS.jai_tax_accounts  jta,
APPS.GL_SETS_OF_BOOKS  gsob,
APPS.hr_operating_units  hou,
APPS.org_organization_definitions  ood,
APPS.hr_locations_all  hla,
APPS.GL_CODE_COMBINATIONS_KFV gcck,
APPS.GL_CODE_COMBINATIONS_KFV gcck1,
APPS.GL_CODE_COMBINATIONS_KFV gcck2,
APPS.GL_CODE_COMBINATIONS_KFV gcck3,
APPS.GL_CODE_COMBINATIONS_KFV gcck4,
APPS.GL_CODE_COMBINATIONS_KFV gcck5,
APPS.jai_reporting_associations  jra
WHERE 1=1
AND jr.regime_id=jtt.regime_id
AND jtt.TAX_TYPE_ID=jta.TAX_ACCOUNT_ENTITY_ID
AND jta.LEDGER_ID=gsob.SET_OF_BOOKS_ID
AND jta.ORG_ID=hou.ORGANIZATION_ID
AND jta.ORGANIZATION_ID=ood.ORGANIZATION_ID
AND jta.LOCATION_ID=hla.LOCATION_ID
AND jta.INTERIM_RECOVERY_CCID=gcck.CODE_COMBINATION_ID(+)
AND jta.RECOVERY_CCID=gcck.CODE_COMBINATION_ID(+)
AND jta.INTERIM_LIABILITY_CCID=gcck1.CODE_COMBINATION_ID(+)
AND jta.LIABILITY_CCID=gcck1.CODE_COMBINATION_ID(+)
AND jta.EXPENSE_CCID=gcck2.CODE_COMBINATION_ID(+)
AND jta.ROUNDING_CCID=gcck3.CODE_COMBINATION_ID(+)
AND jta.SUSPENSE_CCID=gcck4.CODE_COMBINATION_ID(+)
AND jta.ADVRCPT_SUSPENSE_CCID=gcck5.CODE_COMBINATION_ID(+)
AND jtt.TAX_TYPE_ID=jra.ENTITY_ID(+)
AND jtt.TAX_TYPE_CODE=jra.REPORTING_CODE(+)
AND hou.name= '&&';

Oracle EBS GST-OFI Transaction Source

Oracle EBS GST-OFI Transaction Source:-
Configuration:OFI Transaction Source,
Responsibility:Receivables Manager,
Navigation:Setup->Transactions ->Sources
Tables:-
RA_BATCH_SOURCES_ALL
HR_OPERATING_UNITS
RA_GROUPING_RULES
XLE_ENTITY_PROFILES
ra_cust_trx_types_all
ra_batch_sources_all

Example:-

SELECT DISTINCT
hou.NAME "Operating Unit"
,xep.name "LEGAL ENTITY"
,rbsa.name "Name"
,DECODE (rbsa.batch_source_type, 'INV', 'Manual', 'Imported') "Type"
,rbsa.description "Description"
,DECODE (rbsa.status, 'A', 'Yes', 'No') "Active"
,TO_CHAR (rbsa.start_date,'DD-MON-YYYY') "Start Date"
,TO_CHAR(rbsa.end_date,'DD-MON-YYYY') "End Date"
,rbsa.auto_batch_numbering_flag "Automatic Bactch Numbering"
,rbsa.last_batch_num "Last Number 1"
,DECODE (rbsa.auto_trx_numbering_flag, 'Y', 'Yes', 'No') "Automatic Transaction Num"
,rbsa.last_batch_num "Last Number 2"
,rbsa.copy_doc_number_flag
,rbsa.allow_duplicate_trx_num_flag
,rbsa.copy_inv_tidff_to_cm_flag
,rbsa.gen_line_level_bal_flag
,rbsa.receipt_handling_option
,DECODE(rbsa.default_reference, '1','interface_header_attribute1', '4', 'interface_header_attribute4', '8', 'interface_header_attribute8') "Reference Field Default Value"
,rctty.name "Standard Transaction Type"
,rbsa1.name "Credit Memo Batch Source"
,rbsa.invalid_lines_rule "Invalid Lines"
,rbsa.gl_date_period_rule "GL Date Period"
,rgr.name "GROUPING RULE"
,DECODE (rbsa.create_clearing_flag, 'Y', 'Checked', 'Unchecked') "Create Clearing"
,DECODE (rbsa.sales_credit_type_rule, 'Y', 'Checked', 'Unchecked') "Allow Sales Credit"
,rbsa.sold_customer_rule "Sold To Customer",rbsa.bill_customer_rule "Bill To Customer"
,rbsa.bill_address_rule "Bill To Address"
,rbsa.bill_contact_rule "Bill To Contact"
,rbsa.ship_customer_rule "Ship To Customer"
,rbsa.ship_address_rule "Ship To Address"
,rbsa.ship_contact_rule "Ship To Contact"
,rbsa.receipt_method_rule "Payment Method Rule"
,rbsa.customer_bank_account_rule "Customer Bank Account"
,rbsa.invoicing_rule_rule "Accounting Invoice Rule"
,rbsa.accounting_rule_rule "Accounting Rule"
,rbsa.accounting_flexfield_rule "Accounting Flex field"
,DECODE (rbsa.derive_date_flag, 'Y', 'Checked', 'Unchecked') "Derive Date"
,rbsa.term_rule "Payment Rule"
,rbsa.rev_acc_allocation_rule
,rbsa.cust_trx_type_rule
,rbsa.memo_reason_rule
,rbsa.sales_territory_rule
,rbsa.inventory_item_rule
,rbsa.unit_of_measure_rule
,rbsa.ship_via_rule
,rbsa.related_document_rule
,rbsa.salesperson_rule
,rbsa.sales_credit_type_rule
,rbsa.sales_credit_rule
FROM APPS.RA_BATCH_SOURCES_ALL RBSA,
APPS.HR_OPERATING_UNITS hou,
APPS.RA_GROUPING_RULES rgr,
APPS.XLE_ENTITY_PROFILES xep,
APPS.ra_cust_trx_types_all rctty,
APPS.ra_batch_sources_all rbsa1
WHERE 1=1
AND rbsa.org_id = hou.organization_id 
AND rbsa.LEGAL_ENTITY_ID=xep.LEGAL_ENTITY_ID(+) 
AND RBSA.GROUPING_RULE_ID=rgr.GROUPING_RULE_ID(+) 
AND rbsa.credit_memo_batch_source_id = rbsa1.batch_source_id (+) 
AND rbsa.default_inv_trx_type =rctty.cust_trx_type_id (+)
AND  rbsa.org_id = rctty.org_id (+) 
AND (rbsa.name LIKE '%OFI%' )
AND rbsa.CREATED_BY NOT IN ('-1','0','1','3','4','5','6','7') 
AND rbsa.end_date IS NULL
AND hou.name= '&&';

Oracle EBS GST

The Tax defaulting, calculation and accounting requirement arising from the Central Excise, Customs, Sales Tax and Income Tax regimes.

Indian indirect tax regimes transitioned to GST Regime in July of  2017 where majority of the indirect taxes have been condensed in to the Goods and Services Tax (GST). The India GST is a country-level destination based indirect tax Applied on Supply of goods or services as against the previous concept of tax on the manufacture of goods, on sale of goods, or on provision of services. 

Based on the principle of destination based consumption taxation, the state portion of the revenue from GST goes to the consuming state Central GST (CGST) and State GST (SGST/UTGST) is applied in the course of intra-state supplies where both the taxes are computed on the same taxable basis Integrated GST (IGST) is levied on inter-State supply. IGST is applicable for Interstate supplies as well as

for cross-country supplies (import and export).

GST is applicable on supply of all goods and services based on Harmonized System of Nomenclature (HSN codes).  

Oracle Financials for India now supports the indirect tax regime through Goods and Service Tax (GST). 

 

Following are the basic setups required to use Oracle Financials for India:

Defining tax configuration

Defining reporting types

Defining Tax Configuration:

Using Tax Configuration, It can be define different tax regimes based on business requirements, 

the tax types, tax codes and so on.

Following things need to do in the tax configuration:

Defining Regime, Tax Types, Tax Rates, Tax Categories, Tax Rules, Common Configurations, Specific Functionality, Party Registration, Creating Item Classification, Item Category, Document Sequencing, Interface Tax Mapping Setting Up Exemptions.

GST Regime:-

Configuration:Regime, 
Responsibility:Oracle Financials For India, 
Navigation:Tax Configuration ->Define Regime
Tables:-
APPS.JAI_REGIMES
APPS.JAI_REGIMES_V
APPS.JAI_TAX_ROUNDING
APPS.JAI_REPORTING_ASSOCIATIONS

Example:-

SELECT DISTINCT 
jr.REGIME_CODE
,jr.REGIME_NAME
,jr.EFFECTIVE_FROM  "Start Date"
,jr.EFFECTIVE_TO "End Date"
 ,decode(jr.REGIME_TYPE,'T','Transaction Tax','W','Withholding Tax')  "Regim Type"
 ,jrv.TAX_AUTHORITY_DESC "Tax Authority"
 ,jrv.TAX_CALENDAR_DESC  "Tax Calendar"
 ,jr.CONVERSION_TYPE  "Conversion Rate Type"
 ,decode(jtr.ROUNDING_BASIS,'TAX','Tax amount','TAXABLE','Taxable amount')  "Rounding Basis"
 ,decode(jtr.ROUNDED_TO, 'ND','Nearest Decimal') "Rounded To"
 ,jtr.ROUNDING_RULE
 ,jtr.EFFECTIVE_FROM "Rounding-Start Date"
 ,jtr.EFFECTIVE_TO "Rounding-End Date"
 ,jra.REPORTING_TYPE_NAME
 ,jra.REPORTING_CODE
 ,jra.REPORTING_CODE_DESCRIPTION
 ,jra.EFFECTIVE_FROM "RC Start Date"
 ,jra.EFFECTIVE_TO "RC End Date"
 FROM APPS.JAI_REGIMES jr
,APPS.JAI_REGIMES_V jrv
,APPS.JAI_TAX_ROUNDING  jtr
, APPS.JAI_REPORTING_ASSOCIATIONS  jra
WHERE 1=1
AND jr.REGIME_ID=jrv.REGIME_ID
AND jr.REGIME_ID=jtr.REGIME_ID(+)
AND jtr.REGIME_ID=jra.REGIME_ID(+);