Category Archives: Uncategorized
Tax Rules – Oracle Financials for India GST India
Define Tax Rate – Oracle Financials for India GST India
Query to Fetch Item Transaction Defaults in Oracle R12
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
Define Tax Regime – Oracle Financials for India GST India
The Set of Tax Rules that Determines the Treatment of Taxes administered By Tax Authority.
There can be Multiple Tax Regime in one Country or Single Tax Regime In one Country.
India Was Administered With Multiple Tax Regime Till 01st July 2017 With Excise for Manufacturing, VAT for Manufacturing and Value Addition, Service Tax for Service Related Transaction.
After 01st July 2017, All the Multiple Regimes Has been Subsumed By One Regime Goods and Service Tax.
Navigation
Oracle Financials For India —>Tax Configurations—>Regime
Pre Requisites for Creating GST Tax Regime:
1.Tax Authority — A Government Entity That regulates tax Laws administers and audit taxes.
2.Reporting Codes are Optional
Define Tax – Oracle Financials for India GST India
Tax is a Classification of Charge Imposed by Government through Tax Authority
New Taxes can be Created Using the Define Tax Type Form. In the GST Regime, There are Three Major Taxes which would be created
3. Integrated Goods and Service Tax – IGST
Navigation
Oracle Financials For India —>Tax Configuration—>Define Tax Type
Oracle Financials for India – GST India Regime to Rate Flow
We will Define Regime till Tax Rate and Associated Various Other Entities such as Taxes, Tax Authorities, Rules Etc.,
One Tax can only be Governed By one Tax Authority, But on Tax Authority can Govern one or More Taxes.
Oracle India GST Solution has below Mentioned Setups to be done for Regime to Rate Flow.
1.Define Regime
2.Define Tax Type
3.Define Tax Status
4.Define Tax Rate
5.Define Tax Category
6.Define Item Classification
7.Define Tax Rules
We will See The Above Mentioned Setups One By One in Upcoming Posts.
Define Tax Authority – OFI GST India
Define Tax Authority
Units of Measurement Conversion
Oracle E Business Suite Navigation
Inventory —>Setup —>Units of Measure –> Conversions
UOM Classes In Oracle R12