How Currencies Are Processed

When you define a data rule, you can specify how to extract exchange rates from the Enterprise Resource Planning (ERP) source system. 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 Oracle Hyperion Planning or Oracle Hyperion 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 Planning or Financial Management application. (It is important to set up the currencies in the Planning or Financial Management application with ISO currency codes.) Then, perform any currency conversions with those rates, as nothing is recalculated as part of this process.

Any data that is coming in with the default currency of the application is loaded to locale.

Note:

Intersection checks are not performed on exchange rates. In addition, you cannot drill through on exchange rates.