Oracle XML Publisher – Presentation/ training
The Multiple Reporting Currencies (MRC) feature allows you to report and maintain accounting records at the transaction level, in more than one functional currency. You do this by defining one or more reporting sets of books, in addition to your primary set of books. In your reporting sets of books, you maintain records in a functional currency other than your primary functional currency. You can set up multiple reporting sets of books and associate them with a primary set of books.Your primary functional currency is the currency you use to record transactions and maintain your accounting data within Oracle Applications. The functional currency is generally the currency in which you transact most of your business and the one you use for legal reporting.
A reporting functional currency is a currency other than your primary functional currency for which you need to report accounting data. You must define a set of books for each of your reporting functional currencies.
· General Ledger
The following Oracle Applications support Multiple Reporting Currencies:
2) Your company is multinational, and you need to report financial information in a common functional currency other than that of the transaction or your primary functional currency.
1) You operate in a country whose unstable currency makes it unsuitable for managing your business. As a result, you need to manage your business in a more stable currency and still be able to report your transactions and account balances in the unstable local currency.
Typically, you should consider using MRC when:
When to Use MRC:
Oracle Subledgers: When you enter transactions into the subledgers of Oracle Applications that support MRC, the transactions are converted to your reporting functional currencies at the time of original entry. As a result, your reporting currency information is immediately available for inquiry and reporting in the subledgers. Each inquiry or report that normally displays information in the primary functional currency can also be displayed in any of the associated reporting currencies. To do so, you log into a reporting responsibility, then view and report transactions in the reporting currencies associated with that responsibility. You must post subledger transactions to General Ledger in both the primary set of books and in each reporting set of books. After you have posted the transactions, you can log into a General Ledger reporting responsibility, post the newly created journals, then report on the journals and the account balances of the associated reporting set of books.
Oracle General Ledger: For General Ledger journals, you must complete the posting process in both your primary set of books and each associated reporting set of books before you can report on the updated balances. Note that separate balances are updated for each set of books.Before you can report on your updated balances, you must also post your subledger transactions to General Ledger from both your primary and associated reporting sets of books, and post the newly created journals in both your primary and associated reporting sets of books. Each General Ledger report or inquiry that normally displays information in the primary functional currency can also be displayed in any of the associated reporting currencies. To inquire or report on the account balances of a reporting set of books, you log into the associated General Ledger reporting responsibility. When you inquire on account balances in a reporting set of books, you can drill down to the subledger details (in your reporting functional currency) using General Ledger’s standard drilldown features.
Transition Period: If you currently use Oracle Applications, you can continue to maintain your current set of books in your national currency and use MRC to begin reporting transactions and financial results in the Euro. If you are implementing Oracle Applications for the first time, you can set up your primary set of books using Euro as the functional currency and use MRC to report transactions and financial results in your national currency.
Currency Conversion: MRC observes the fixed-rate relationships you defined between the Euro and EMU currencies, as well as the effective starting dates of those relationships, when converting transaction amounts to or from the Euro or EMU currencies. When converting amounts from your primary functional currency to your reporting functional currencies, MRC fully complies with the conversion guidelines established by the European Commission.
Setting Up MRC The following provides a summary of the steps you must follow to set up MRC in your applications. These steps are described in more detail in the next section. Note: You must install MRC before you can begin the setup steps in this section. See: Oracle Applications Installation Manual for information about installing MRC.
Step 2 Enable and/or define reporting currencies :Currencies window(General Ledger)
Step 3 Define reporting sets of books :Set of Books window(General Ledger)
Step 4 Assign reporting sets of books to primary set of books: Assign Reporting Sets of Books window(General Ledger)
Step 5 Define conversion options for each application: Conversion Options window(General Ledger)
Step 6 Define General Ledger conversion rules: GL Conversion Rules window(General Ledger)
Step 7 Define reporting responsibilities : Responsibilities window(System Administrator)
Step 8 Assign reporting sets of books to reporting responsibilities : System Profile Values window (System Administrator)Daily rates are used to convert your primary set of book’s transactions to the appropriate reporting currencies. If you do not currently maintain daily rates, you must do so when you implement MRC.