Configure global currencies in Functional Setup Manager.
For information about setting up currencies, refer to the following task in Functional Setup Manager: Common Areas and Dimensions Configurations\ Configure Global 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.