Tax Category – Oracle Financials for India GST

Tax Category:

Tax Category is a Group or Set of Tax Which Will Default to a Transaction based on certain rules.

Navigation

Oracle Financials for India —> Tax Configurations—> Tax Category

This is a Operating Unit Dependent Setup.

Precedence is Expected to Always be “0” Which Denotes the Assessable Value of Goods or Service in GST.

Tax Rules – Oracle Financials for India GST India

Tax Rule Determines the Applicability of Various Tax Category on a Purchase or Sales Transaction Based on Certain Basis such as Item Classification, Application, Bill To, Ship To, Ship From, Customer Reporting Code, First Party Registration Number, First part Reporting Code, Item Reporting Code, Supplier Reporting Code, Third Party Registration Number.

Navigation:

Oracle Financials for India —> Tax Configurations—> Tax Rules

Define Tax Rate – Oracle Financials for India GST India

Each Tax Type Can have Different Tax Rate Depending Upon the Various Status and Statutory Advisories.

Navigation : Oracle Financials for India —> Tax Configurations—> Tax Rate

This Setup is Operating Unit Dependent.

 

Add Other Relevant Information’s in Accounts and Reporting Tabs and Save the Tax Rate.

 

Query to Fetch Item Transaction Defaults in Oracle R12

Below Mentioned Query Will Fetch Item Transaction Defaults. For Filtering Based in Organization or Item Use the Highlighted Lines with suitable Values. 

SELECT MSIB.SEGMENT1 as ITEM,
  OOD.ORGANIZATION_CODE ,
  MLSS.Meaning as DEFAULT_FOR_SUB,
  MLSL.Meaning DEFAULT_FOR_SLOC,
  MISD.subinventory_code AS DEFAULT_SUB,
  MILD.subinventory_code AS DEFAULT_SUB_SLOC,
  MILK.CONCATENATED_SEGMENTS
FROM MTL_ITEM_LOC_DEFAULTS MILD,
  MTL_SYSTEM_ITEMS_B MSIB,
  ORG_ORGANIZATION_DEFINITIONS OOD,
  MTL_ITEM_SUB_DEFAULTS MISD,
  MFG_LOOKUPS MLSS,
  MFG_LOOKUPS MLSL,
  MTL_ITEM_LOCATIONS_KFV MILK
WHERE MILD.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND MISD.INVENTORY_ITEM_ID  = MSIB.INVENTORY_ITEM_ID
AND MILD.ORGANIZATION_ID     = MSIB.ORGANIZATION_ID
AND MISD.ORGANIZATION_ID     = MSIB.ORGANIZATION_ID
AND MILD.ORGANIZATION_ID     =MISD.ORGANIZATION_ID (+)
AND OOD.ORGANIZATION_ID      = MSIB.ORGANIZATION_ID
AND MILK.ORGANIZATION_ID     = MILD.ORGANIZATION_ID
AND MILD.SUBINVENTORY_CODE   = MISD.SUBINVENTORY_CODE(+)
AND MILD.DEFAULT_TYPE        = MLSL.Lookup_CODE
AND MISD.DEFAULT_TYPE        = MLSS.LOOKUP_CODE
and MILD.DEFAULT_TYPE        = MISD.DEFAULT_TYPE(+)
AND MLSS.LOOKUP_TYPE         = ‘MTL_DEFAULT_SUBINVENTORY’
AND MLSL.LOOKUP_TYPE         = ‘MTL_DEFAULT_LOCATORS’
–AND OOD.ORGANIZATION_CODE    = ‘XXXXXX‘
–AND MSIB.SEGMENT1           IN (‘XXXX’)
AND MILD.LOCATOR_ID        = MILK.INVENTORY_LOCATION_ID