Loading Exchange Rates to Financial Management

When you define a data rule for an Oracle Hyperion Financial Management target application, you can specify how to extract exchange rates from the Enterprise Resource Planning (ERP) source system. Exchange rates are captured, if applicable, for the currency rate account for the Beginning Rate, currency rate account for the Ending Rate, and the currency rate account for the Average Rate.

If your target application has the multi-currency option enabled, you can specify how to process exchange rates. All rates are extracted and inserted into the AIF_HS_EXCHANGE_RATES table. This table is populated using the ISO currency code for each currency from the source system. The ISO numeric code is not used in this processing. Exchange rates are pushed into Financial Management based on a match between the ISO currency code in the AIF_HS_EXCHANGE_RATES table and the currencies defined in the multi-currency Financial Management application. (It is important to set up the currencies in the Financial Management application with the ISO currency).

Note:

Exchange Rates are usually loaded to the [None] Entity member. Oracle Hyperion Financial Data Quality Management, Enterprise Edition references the Financial Management application settings to view the To Currency and From Currency dimensions automatically.

To load exchange rates to 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 account names in the following fields:

   • Currency Rate Account for Beginning Rate

   • Currency Rate Account for Beginning Rate

   • Currency Rate Account for Beginning Rate

   For information about working with other application options, see Registering Target Applications.

   
   
   
5. On the Workflow tab, under Data Load, select Data Load Rule.
6. In Data Load Rule, select a data load rule or click Add.
7. Select the Source Options tab.
8. Select the Beginning, Ending, and Average exchange rate options.

   Enterprise Resource Planning (ERP) source systems maintain comprehensive exchange rate information for transaction processing. Target applications can use this information by extracting the exchange rates. You can select a beginning, ending, and average rate type from the source system. (The types in the source system may not explicitly define those rates types but are mapped to the rates types in the FDMEE interface table.)

   For more information about source options, see Defining Source Filter Options for E-Business Suite Source Systems.