9.4 Currency Rates

OFSAA Rate Management's Currency Rates module uses the currencies defined and activated in the Currency module to support the creation and maintenance of historical exchange rates. Currency exchange rates are utilized in:

• OFS Funds Transfer Pricing (OFS FTP) Ledger Migration processes
• OFS Asset Liability Management (OFS ALM) Currency Consolidation process (see the OFS Asset Liability Management User Guide)
• OFS Profitability Management multi-currency allocations.
• OFS Hedge Management and IFRS Valuations (see the Oracle Hedge Management and IFRS Valuations User Guide)

To view the Currency Rate, navigate to Common Object Maintenance, select Rate Management, and then select Currency Rates. In this window, you can manage historical exchange rates between currencies.

For ALM, FTP, and PFT, From Currency defaults to the Initial Currency selection from the Assumption Management defaults in the active Application Preferences window. You can select another From Currency from the drop-down list that displays all Active currencies.

• Preparing to Work with Exchange Rate Data
  To view, edit, or delete the exchange rate data, you must enter the To Currency value. With the From Currency, the To Currency drop-down list displays only Active currencies.
• Adding Exchange Rate Data
  After you have specified a value for To Currency, the Floating Currency Rates section appears. To define a Fixed Rate relationship, select the Fixed Rate Type and replace the Floating Currency Rates with the Fixed Currency Rates.
• Adding Multiple Exchange Rates
  Click Add to add additional blank rows to enter the additional Effective Dates and Exchange Rates. After adding the multiple new exchange rates, click Save.
• Editing Exchange Rate Data
  Select the check box on the left-hand side of any row to enable the Edit icon. After clicking Edit, the row becomes active to edit the Effective Date and (or) the Exchange Rate. Click Save to save the changes.
• Viewing Exchange Rate Data
  By default, both the Floating Currency Rates pane and the Fixed Currency Rates pane display the most recent month of historical exchange rate data. You can control the amount of data displayed by selecting a different value from the Effective Date Range drop-down list in the Currency Selection window.
• Deleting Exchange Rate Data
  Select one or more check boxes on the left-hand side of any row to enable the Delete icon. After clicking Delete, a confirmation message is displayed. Click Ok.
• Data Loader
  The Data Loader icon executes a function to import historical Currency rates for all defined Currencies. For more information on setting up the automated process, see the OFS Data Model Utilities User Guide.
• Excel Compatibility
  This functionality is used for adding or editing historical exchange rates from an Excel sheet. You can right-click on any cell in the table and perform the following actions: