Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise 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 Siebel Customer-Centric Enterprise 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 IA_XRATES table. After the exchanges rates are available in the IA_XRATES table, the ADI can look up these exchange rates from the IA_XRATES 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 SOURCE_ID, XRATE_TYPE_CODE, XRATES_TYPE_DESC, and KEY_ID.
   • The SOURCE_ID default is OAP11. If your source is not Oracle, then you can reconfigure this ID.
   • The XRATE_TYPE_CODE and XRATE_TYPE_DESC default is Corporate.
   • The KEY_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 TF_XRATES 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 IA_XRATES table.