Introduction

This 20-minute tutorial shows you how to automatically translate data to reporting currencies in Planning forms.

Background

In a multicurrency environment, you can enter or import exchange rates for all your Planning business process currency members. Exchange rates are converted or translated within Planning by running business rules.

Exchange Rates to Main Currency Form

Enter exchange rate data to the exchange rate form that was automatically created and seeded during application creation. The exchange rate form is called Exchange Rates to Main Currency; for example, Exchange Rates to USD.

Exchange rates are stored in the Account dimension and they contain the ending and average rates used to convert  currencies into the main currency. These rates are in FX Rates-Average and FX Rates-Ending,  are locked, and can't be deleted. Users with view permissions can view the rates for the currencies on the Exchange Rates to Main Currency form.

Note:

To learn more about importing exchange rates, see the Loading Data in Planning tutorial.

Calculate Currencies Rule

The Calculate Currency rule converts the input values from the current currency to the reporting currencies. You can set up your forms to automatically run the Calculate Currency rule when you save data.

You can also manually launch the rule to convert data from one currency to the reporting currencies. After the Calculate Currency rule is run, view the converted values by selecting that currency's member from the Currency dimension.

You can't enter data into a reporting currency. You can enter data only into a local, or input, currency.

Prerequisites

Cloud EPM Hands-on Tutorials may require you to import a snapshot into your Cloud EPM Enterprise Service instance. Before you can import a tutorial snapshot, you must request another Cloud EPM Enterprise Service instance or remove your current application and business process. The tutorial snapshot will not import over your existing application or business process, nor will it automatically replace or restore the application or business process you are currently working with.

Before starting this tutorial, you must:

  • Have Service Administrator access to Planning for EPM Enterprise Cloud Service.
  • Upload and import this snapshot into your Planning instance.

Note:

If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

Opening the Exchange Rates to USD Form

In this section, you open the Exchange Rates to USD form.

The Exchange Rates to USD (Main Currency) form is automatically created and seeded during the creation of the Planning business process. You enter exchange rate data in this form. If you imported exchange rates, you can view the imported exchange rates in this form.

You enter exchange rates by period for all input currencies against the main currency. You must enter the values across all dimension intersections for which you want to see the converted data.

  1. From the Planning home page, click Data.
  2. Click Exchange Rates to USD.
    3. Exchange Rates to USD form

    The form displays the currencies and exchange rates used in the Planning business process. The exchange rates are imported into the No Entity member, where all other entities later take it from when the business rule to convert the data is run.

  3. Click Close.

Adding Calculate Currencies to Forms

To view reporting currency values on an input form, add the Calculate Currencies business rule. In this section, you modify the Multicurrency - Input and Reporting form to automatically run the rule when data in the form is saved.

Guidelines when designing forms that calculate reporting currency:

  • Ensure that any forms created have the same intersection as that of the Exchange Rates to Main Currency form, with respect to Scenario, Version, and Year.

    • For example, in the previous section, the Scenario, Version, and Year should match the ones in the form used in this section.

  • Ensure that both the input and converted forms have the same structure, the only difference between the forms being the currency.
  1. Click Navigator, and then under Create and Manage, click Forms.

    2. Form and Ad Hoc Grid Management is displayed.

    Form and Ad Hoc Grid Management
  2. Select Multicurrency - Input and Reporting and click ( Edit icon ) Edit.
  3. Click the Layout tab.
  4. Review the form layout.
    5. Form layout

    The page includes the following data point-of-view:

    • Years: FY22
    • Scenario: Plan
    • Version: Base
    • Entity: East

    Period and Currency are in the column axis. Currency members include both input and reporting currencies. Accounts are in the row axis.

  5. Click the Business Rules tab.

    6. The Selected Business Rules lists the predefined Calculate Currencies and Calculate Form business rules.

    Business rules tab

    The Calculate Currencies business rule is based on the dimensions and members on the form. It converts data from the local currency to the reporting currency specified on the form, applying the exchange rate conversions. It doesn't calculate subtotals. To subtotal values, run the Calculate Form business rule (or a customized business rule that includes aggregation) after converting currencies.

    You can select if you want to run these rules within the form, and when you want to run the rule.

  6. In the Busines Rules Properties section, select Run After Save for both Calculate Currencies and Calculate Form.
    7. Business Rules Properties - Run After Save
  7. Click Finish.
  8. Close Form and Ad Hoc Grid Management. Click ( X ) Close.

Entering and Converting Currencies

  1. From the Planning home page, click Data.
  2. Click Multicurrency - Input and Reporting.

    3. The form is displayed.

    Multicurrency - Input and Reporting form
    • For Jan - USD, enter the following expense values:
    • Hotel: 800
    • Airfare: 800
    • Meetings: 300
    • Meals: 800
    • Car Rental: 250
    • Other T&E Expenses: 350
    Enter data
  3. Click Save.

    4. The Calculate Currencies and Calculate Form business rules were ran against the data saved on the form and translated the data to the reporting currencies.

    Data translated to reporting currencies on the form