Monday, September 16, 2013

EBTax Basics

EBTax Is a rule based engine introduced in Oracle R12. We can apply different tax rates based on the location, product category, supplier classification …etc. . We can also have tax exemption and exception

Tax structure is defined in Regime to Rate flow. The components of Regime to Rate are
1.       Regime: Regime is the highest level in the tax structure . We can define tax Regime at country , group of countries or a tax Zone level.

Note: Until we assign the Regime to appropriate party tax will not be applied on the transaction associated to the party. Parties assigned to regimes are First Party Legal Entity’, ‘Operating Unit owning Tax Content’

2.       Tax: This setup should be done at tax authority classification level with in a region Status. Eg: State, County, City etc

Note: We cannot enable the Tax definition until we complete our Regime to rate structure and tax rules . If Tax is not enables tax will not be applied on Transaction

3.       Status : We define a tax status to group one or more tax rates that are of the same or similar nature
4.       Jurisdiction: jurisdiction is a geographic region or tax zone where a specific tax authority levies
a tax. Each State, Country and city that changes tax is defined as jurisdiction
5.       Rate: Actual tax rate is given in the Rate setup. We can have different tax rates based on the data range

Note: We should one default tax rate under each Tax.  We can setup default tax account at the tax rate level


Once the Regime to rate definition is complete we need to setup tax applicability rules based on different criteria 


Friday, August 2, 2013

Primary Ledger , Secondary Ledger, Reporting Currency 


Primary Ledger is a key configuration in any oracle implementation. This setup is required to do any Journal entries / Transactions in Oracle

This is where we will be selection 4c’s

  •      Companies accounting structure (chart of accounts)
  •      Accounting calender
  •          Functional currency
  •          Accounting method


along with other optional features like translation, inter-company journals , reversing criteria etc

Secondary Ledger is a optional feature . Secondary Ledger is not a actual transaction ledger, this is used to capture the Journal entries/ transactions that were entered in Primary ledger

Secondary ledger can have all the 4’c different from your primary Ledger. This makes it easy to maintain balances as required by in country accounting and also in international financial standard

Reporting Currency is an optional feature. This will allow having balances or transactions in a currency that is different from your Functional currency .


This helps companies to maintain balances in different currency . This is similar to MRC feature in Oracle 11i