Changing the Default Currency in Analytics Applications

In Oracle BI Applications, you might see a dollar sign used as the default symbol when amounts of money are displayed.

To change this behavior, you must edit the currencies.xml file. The currencies.xml file is located in the following directories:
  • Windows: ORACLE_HOME\bifoundation\web\display\currencies.xml

  • UNIX: ORACLE_HOME/bifoundation/web/display/currencies.xml

To change the default currency in Analytics Applications:

  1. In a text editor, open the currencies.xml file.
  2. Look for the currency tag for the warehouse default (tag="int:wrhs"):
    <Currency tag="int:wrhs" type="international" symbol="$" format="$#" digits="2"
    displayMessage="kmsgCurrencySiebelWarehouse">
       <negative tag="minus" format="-$#" />
    </Currency>
    
  3. Replace the symbol, format, digits and negative information in the warehouse default with the information from the currency tag you want to use as the default.

    For example, if you want the Japanese Yen to be the default, replace the contents of the warehouse default currency tag with the values from the Japanese currency tag (tag="loc:ja-JP"):

    <Currency tag="loc:ja-JP" type="local" symbol="©" locale="ja-JP" format="$#"
    digits="0">
       <negative tag="minus" format="-$#" />
    </Currency>
    

    When you are finished, the default warehouse currency tag for Japanese should look like the following example:

    <Currency tag="int:wrhs" type="international" symbol="©" format="$#" digits="0"
    displayMessage="kmsgCurrencySiebelWarehouse">
       <negative tag="minus" format="-$#" /> 
    </Currency>
    
  4. Save and close the currencies.xml file.