What are the amounts Oracle Business Analytics Warehouse uses to store currency?

Transactions may involve multiple currencies that require a common currency to make the reports
meaningful. What are the amounts Oracle Business Analytics Warehouse uses to store currency?

Transactions may involve multiple currencies that require a common currency to make the reports
meaningful. What are the amounts Oracle Business Analytics Warehouse uses to store currency?

A.
Global Currency (two common currencies), Document Currency,Local Currency

B.
Currency Code, Currency Name

C.
Currency Symbol, Currency Name

D.
Report Currency

Explanation:
Currency lookups are required because your business may have transactions
involving multiple currencies. To create a meaningful report, you have to use a common currency.
The Oracle Business Analytics Warehouse provides a means for converting a variety of
currencies, as well as prepackaging the following three currency types for each amount stored in
the Oracle Business Analytics Warehouse:
*Document currency. The currency of the transaction. For example, if you purchase a chair from a
supplier in Mexico, the document currency is probably the Mexican peso.
*Local currency. The currency in which the financial books, including the transaction, are closed.
For example, if your business organization is located in France and orders a part from a supplier in
Britain, it may pay in British pounds, but it closes its books in French francs. In this case the local
currency for the transaction is French francs and the document currency for the transaction is
British pounds. The local currency is useful when each business unit of the enterprise creates its
own internal reports. For example, your Japanese site may produce internal reports using
Japanese yen, while your United States site may produce internal reports using United States
dollars.
*Global currencies. Out of the box, Oracle BI Applications provides three global currencies, which
are the standard currencies used by your entire enterprise. For example, if a multinational
enterprise has its headquarters in the United States, its group currency is probably U.S. dollars.
The global currency is useful when creating enterprise-wide reports. For example, a user might
want to view enterprise-wide data in other currencies

Oracle Business Intelligence Applications Installation and Configuration Guide >

Configuring Common Components of the Oracle Business Analytics Warehouse > About
Document, Local, and Global Currencies



Leave a Reply 0

Your email address will not be published. Required fields are marked *