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 Financial Consolidation and Close
  6. Loading Financial Consolidation and Close Exchange Rates

Loading Financial Consolidation and Close Exchange Rates

When you define a data rule for a Financial Consolidation and Close target application, you can specify how you want Data Management to extract exchange rates.

For Financial Consolidation and Close, the dimensionality of the exchange rates are:

  • Period

  • Average Rate

  • Ending Rate

  • Scenario

  • Year

  • View

  • Entity

  • From Currency

  • To Currency

  • Rates Essbase cube name

For example a sample Financial Consolidation and Close application file may have the following values: 

Period,FCCS_Average Rate,FCCS_Ending Rate,Point-of-View, Data Load Cube Name
Jan,0.2927,1.9549,"Actual,FY14,FCCS_Periodic,FCCS_Global Assumptions,From_CNY,USD",Rates
Jan,2.4584,0.7007,"Actual,FY14,FCCS_Periodic,FCCS_Global Assumptions,From_COP,USD",Rates
Jan,1.6824,0.6465,"Actual,FY14,FCCS_Periodic,FCCS_Global Assumptions,From_DKK,USD",Rates
Jan,2.9578,2.7619,"Actual,FY14,FCCS_Periodic,FCCS_Global Assumptions,From_GBP,USD",Rates
Jan,1.2788,2.2206,"Actual,FY14,FCCS_Periodic,FCCS_Global Assumptions,From_CAD,USD",Rates
Based on the first row, exchange rates are applied as follows:

  • Jan (Period)

  • 0.2927 (value for FCCS_Average Rate)

  • 1.9549 (value for FCCS_Ending Rate)

  • Actual (Scenario)

  • FY14 (Year)

  • FCCS_Periodic (View)

  • FCCS_Global Assumptions (Entity)

  • From_CNY (From currency)

  • USD (To Currency)

  • Rates (Cube name)

For Import Formats, the default exchange rate types applies to two members: "FCCS_Average Rate" for the average rate, and "FCCS_Ending Rate" for the ending rate.

In this case, you create an import format with the rate cube as the target, and then map the source data file to this cube.

In the import format, the following dimensions are available for mapping:

  • Average Rate (Value)

  • Ending Rate (Value)

  • View

  • Entity

  • From Currency

Other dimensions are mapped from the selected POV or set in the target application option. It is recommended that you map the target member for "View" to" FCCS_Periodic", and "Entity" to "FCCS_Global Assumptions."

To load exchange rates to Oracle Hyperion Financial Management:

  1. On the Setup tab, under Register, select Target Application.
  2. In the Target Application summary grid, select a Financial Management target application.
  3. After defining the application details in Application Detail, select the Application Options tab.
  4. Specify the members for the following dimensions:

    • Movement

    • Multi GAAP

    • Data Source

    Image shows Application Options tab
  5. From Movement, select the member value for the movement dimension.
    Available options:
    • FCCS_Movements
    • FCCS_CashChange
  6. In Multi GAAP, select the member value for the multi-GAAP.
  7. In Data Source, select the member value for the data source.
  8. Click Save.