Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Common Components of the Oracle Business Analytics Warehouse > Handling European Monetary Union (EMU) Currencies >

Using the Flat File to Supply EMU Exchange Rates

The flat file contains currency conversion rates for all combinations of EMU currencies (including individual EMU member currencies as well as the joint EMU currency, the Euro). This file includes the following combinations:

• EMU to EMU. This is the conversion from the individual currency of one EMU member country to another.
• EUR to EMU. This is the conversion from the joint EMU currency, the Euro, to the individual currency of an EMU member.
• EMU to EUR. This is the conversion from the individual currency of an EMU member to the joint EMU currency, based on the Euro.

If you use this method, the Oracle Business Analytics Warehouse assumes that the source system supplies currency conversion rates between individual EMU member currencies and national currencies for countries outside of the EMU. In addition, this method does not conform to the rounding rules set by the European Monetary Union.

To use this method, you must upload the exchange rates from this flat file to the W_EXCH_RATE_G table. After the exchanges rates are available in the W_EXCH_RATE_G table, the load mapping can look up these exchange rates from the W_EXCH_RATE_G table and convert currency as required.

To load the individual EMU member currency exchange rates using the flat file

1. Before you load the exchange rates from the flat file, if necessary, change the default values in the flat file for the parameters DATASOURCE_NUM_ID, XRATE_TYPE_CODE, XRATES_TYPE_DESC, and integration ID.
   • The XRATE_TYPE_CODE and XRATE_TYPE_DESC default is Corporate.
   • The integration ID uses the XRATE_TYPE_CODE as part of it definition. The Key ID is defined as the concatenation of the From Currency Code, To Currency Code, Exchange Rate Type Code, and the Effective From Date. Therefore, if you change the Exchange Rate Type Code, then you must also modify the Key ID accordingly.
2. Create the session for the M_F_XRATES_EXTRACT mapping, using the file_xrates_emu.csv flat file as the source system file.
3. Run the extract session to load the flat file exchange rates into the W_EXCH_RATE_GS staging table.
4. Create a session for the M_F_XRATES_LOAD mapping.
5. Run the load session to load the exchange rates into the W_EXCH_RATE_G table.