Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Common Components of the Oracle Business Analytics Warehouse >

Handling European Monetary Union (EMU) Currencies


For transactions that take place after the Euro effective date (January 01, 1999), the published exchange rates involving individual EMU member currencies may not be available. To address the need for conversions between the individual currency of an EMU member and any other currency, you may need to set up a mechanism for retrieving these rates. The Oracle Business Analytics Warehouse prepackages two methods for handling European Monetary Union currencies:

  • Flat file (file_xrates_emu.csv)
  • Expression transformation (EXP_CURR_CONVERSION_TRANSFORM).

Each of the two methods is discussed in the following sections.

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.