Oracle R12 EBTAX – Functionality Guide Chapter

Credits :  Mohan Iyer ( Oracle E-Business Suite Financials R12: A Functionality Guide )

E-Business Tax is based on a global system architecture. It is configurable and
scalable for adding and maintaining country-specific c tax content. With E-Business
Tax, you can model your tax requirements according to the needs of local and
international tax requirements.

A brief explanation for each task is as follows:

 Basic tax configuration: The basic tax configuration includes the regime-to-rate fl ow for each Tax Regime. These involve defining a regime, tax, a tax status (standard or exempt), and rates—both for charging tax and recovery rates.

Tax Jurisdictions: A Tax Jurisdiction is the geographic area where a tax is levied by a specific  tax authority.

Party tax profiles : You define  profiles for the parties involved in tax transactions that are set up through a legal entity and Trading Community Architecture. Party tax profiles contain all of the tax information for each party, including tax registrations and party fiscal classifications.

These parties can be you as well as the party you transact with, namely, customers and suppliers.

Fiscal classifications: A fiscal classification is the  way that a tax authority classifies each part of a transaction that includes parties and party sites, and products among other aspects. Fiscal classifications assist in configuring tax rules. The classifications provide one or more qualifications to identify when and how taxes should be calculated.

Exemptions and exceptions: Tax exemptions let you define a party/party site or product as partially or fully exempt from tax. Tax exceptions let you define a special rate for specific products.

Country default controls: This subcomponent lets you specify certain defaults country wise. These defaults are used during transaction entry.

For full chapter – please refer below pdf

Oracle R12 and Fusion – one or multiple Operating Units?

Oracle R12 and Fusion – one or multiple Operating Units?

For any implementation or solution , this question always there, how many operating unit / Business units.  There are always different sceanarios and different module involve to make decision more difficult or need to though through.  I find this white paper very useful for this purpose and sharing for your knowledge.

Direct link –

some more white papers or useful articles on Tax and Oracle EBS –

R12 – Oracle Approvals Management (AME)

Oracle Approvals Management (AME) is a  self‐service Web application that enables you  to define business rules governing the process for approving transactions in Oracle applications that have integrated AME.

Here is very simplified way to explain AME and its usage in Oracle R12


Videos links are here-

Oracle Approvals Management (AME) to Enhance Organizational Productivity 

Oracle Apps Training – Configure AME Roles in R12


OUM – Oracle Unified Methodology

OUM currenet release 6.3 provides support for Application Implementation, Cloud Application Services Implementation, and Software Upgrade projects as well as the complete range of technology projects

OUM provides an implementation approach that is rapid, broadly adaptive, and business-focused. OUM includes a comprehensive project and program management framework and materials.

The Oracle Unified Method provides guidance for: • Project Management • Enterprise IT Strategy, Architecture, and Governance • Business Requirements Collection and Analysis • Mapping and Configuration • Design • Implementation • Technical Architecture • Testing • Performance Management • Data Acquisition and Conversion • Documentation • Organizational Change Management • Training • Transition • Operations and Support

Download –

Training –

YouTbe Vidoe – OUM brief Walkthrough – 

Oracle R12 : Multiperiod Accounting

Supposed that there is a service type company, they have received whole money from their customer, but they have not provided the whole service finally. The whole service will be provided within 12 months from current month. Against accrual basis concept, the company can’t recognize revenue for the whole money amount to current month, even though they received whole money in current month.

Multi Period Accounting (MPA) enables users to create accounting for a single accounting event for more than one GL period. This functionality is primarily used to recognize revenue or a prepaid expense across multiple GL periods.

Within Multi Period Accounting, application provides different ways to Prorate the amounts.

  • First Period
  • Days In Period
  • Total Days In Period
  • 360 Days

The Amount prorated depends on the Proration Type.

Here are some of documentation for further deep dive :

Subledger Accounting , White Paper on Multi Period Accounting (MPA) in R12

Slidershare presentation –  ( By  Prithis Das )

Deep Dive blogs articles –

R12: Subledger Accounting: White Paper Explaining Different Proration Types in Multi Period Accounting  –



How to Be: Oracle Functional Consultant

Here i like to share,  a Video series made by Kabir Khan ( ) .  He did superb job in explaining and outlining Oracle Functional consultant job profile and expectations etc

– By the end of this Video Series you will be able to:
— Where to start?
— Choosing Functional Career Paths
— Aligning previous experience
— Functional specialization and integration
— Answer common queries on Functional Career
— Transaction Cycle, Setup and Implementation
— Technical Knowledge
— Looking for roles and applying for jobs

*He provides training and other services , but I don’t know about those so this video sharing is my personal thought on  this video series only*