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 multicurrency 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 Planning based on a match between the ISO currency code in the AIF_HS_EXCHANGE_RATES table and the currencies defined in the multicurrency Planning application. (It is important to set up the currencies in the Planning 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 Planning application is loaded to locale.
For Financial Management, data is loaded to value dimension specified in the Location. Typically it is set to <Entity Currency>.
Note: | Exchange rates are not displayed in Financial Management. You should manually access them from the AIF_HS_EXCHANGE_RATES table and insert them into Financial Management. |