1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Using Data Management
  3. Administration Tasks
  4. Registering Target Applications
  5. Defining Application Options for Tax Reporting
  6. Tax Reporting Supported Dimensions

Tax Reporting Supported Dimensions

Tax Reporting uses a pre-defined dimensional model. Below are the Tax Reporting dimensions and their data requirements.

Table 2-12 Tax Reporting Supported Dimensions

Dimension Member Description

Year

All members in the Year dimension

Year members include the FY prefix. For example, the year member "2016" is defined as FY16.

Period

Only base members

Standard period members and user defined.

View

FCCS_Periodic

The View dimension is not exposed in the Data Management user interface. (The system defaults to the view dimension to the member named" FCCS_Periodic." )

Currency

All enabled Currency members created under the parent member "Input Currency" and "Entity Currency."

Standard ISO currency members. This dimension is only available when the target Tax Reporting application has been set up as multi-currency.

Consolidation

"FCCS_Entity Input"

The Consolidation dimension allows you to report on the details used to perform the various stages of the consolidation process. The default member should be mapped to "FCCS_Entity Input."

You can also load different override amounts and rates for different source members by location using the Consolidation Value option in Locations. See Defining Locations.

Scenario

 All base members.

Standard user defined scenario members.

Entity

All base members

  

Intercompany

"FCCS_No Intercompany" or ICP_<ENTITY>.

If no intercompany, then use the member "FCCS_No Intercompany." Otherwise, use a user defined ICP member, which is typically ICP_<ENTITY>.

Account

All base members

Any user defined based member.

Movement

FCCS_No Movement, or any base member.

If no movement, then specify member as "FCCS_No Movement. " Otherwise, select the desired movement member.

Example of movement dimension members:

  • TRCS_BookClosing

  • TRCS_TBClosing

  • FCCS_No Movement

  • FCCS_ClosingBalance

  • TRCS_TARFMovements

  • TRCS_ETRTotal

  • TRCS_ClosingBVT

Data Source

All base members for "FCCS_Data Input"

The default is " FCCS_Managed Data."

Multi GAAP

"FCCS_Local GAAP" or any user defined base member.

The default is "FCCS_Local GAAP." You can also use base a member provided by Tax Reporting.

Jurisdiction

Any valid base member. The default member is "TRCS_No Jurisdiction."

The default member is "TRCS_No Jurisdiction," but you can select any valid base member.