When you define a data rule, you can specify how to extract exchange rates from the ERP source system. If your target application has the multi-currency option enabled, you can specify how to process exchange rates. See Defining Target Options for E-Business Suite and PeopleSoft Source Systems.
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.
For a Planning applications, exchange rates are only extracted if the Classic data load method is chosen. If the EPMA data load method is chosen for a Planning application, exchange rates cannot be extracted through ERP Integrator. 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 multi-currency 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.
Note: | The amounts from the source system are the functional amounts only. Entered or translated amounts are not included in the integration. |
Note: | Exchange rates are not interfaced directly into Financial Management. You should manually access them from the AIF_HS_EXCHANGE_RATES table and insert them into Financial Management. |