Oracle Business Analytics Warehouse Currency Preferences

Configure global currencies in Functional Setup Manager (FSM).

To set up currencies, see About Configuring Currencies.

The Oracle Business Analytics Warehouse supports the following currency preferences.

  • Contract currency — The currency used to define the contract amount. This currency is used only in Project Analytics.

  • CRM currency — The CRM corporate currency as defined in the Fusion CRM application. This currency is used only in CRM Analytics applications.

  • Document currency — The currency in which the transaction was done and the related document created.

  • Global currency — The Oracle Business Analytics Warehouse stores up to three group currencies. These need to be pre-configured so as to allow global reporting by the different currencies. The exchange rates are stored in the table W_EXCH_RATE_G.

  • Local currency — The accounting currency of the legal entity in which the transaction occurred.

  • Project currency — The currency in which the project is managed. This may be different from the functional currency. This applies only to Project Analytics.