How to enter Daily Rates Manually in Fusion Application

This article will helps to understand how we can enter Currency daily rates manually step by steps in Oracle Fusion Applications.

As we know all the currencies are already defined in the system. Below are the Rate types already there in the system-

• Corporate- this type is used for management reporting and normally defined once in a month or whenever there is drastic change in the rate of currency.

• Fixed- Fixed rate are for currency which fluctuate very less like USD and AED

• Spot- we upload daily we get from bank and have too much fluctuation

• User- These are the rate specified by the user while entering the transactions

We can create our own exchange rate and can be used in the transaction but normally out of these 4 rates are used.

Let’s first download the installation files from Navigator - Tools - Download Desktop Integrator Installer- Click and install the set up.

Entering Daily Rates

To upload the daily rate we cannot use this screen manually as we have to upload by using spreadsheet functionality.

Let’s assume that we are required to enter the daily rates for currency conversion from United States dollars (USD) to Great Britain pounds sterling (GBP) to each day for our company Apps2Fusion.com

Oracle Application Development Framework (ADF) Desktop Integration is an Excel add-in that must be loaded onto each client.

1. Click the Manage Currency Rates link. Use the Currency Rates Manager page to create, edit, and review currency rate types, daily rates, and historical rates.

2. Click the Daily Rates tab. Use the Daily Rates tab to review and enter currency rates.

 3. Click the Create in Spreadsheet button. Use the Create Daily Rates spreadsheet to enter daily rates in a template that you can save and reuse. Login using your credentials to upload exchange rate manually.

4. Click in the From Currency field. Select the USD.

5.Click in the To Currency field. Select the GBP

6.Enter the required details as shown in the below screen shot-

7.     Click on Submit Button.

8.     Review the Record Status column to verify that all rows were loaded successfully.

9.     Save the template to use to enter daily rates frequently. You can save the spreadsheet to either a local drive or a shared network drive.

10.  Go back to the application and verify the process ID generated.

Add comment