Manage Currency Rates

Manage Currency Rates

The creation of new exchange rate types, as well as the uploading and maintenance of daily rates in Oracle Fusion, will be thoroughly explained in this guide.

Click on the Period Close submenu under the General Accounting menu.

Navigate to Period Close

To access the Currency rates setup, click on the “Manage Currency Rates” hyperlink from the task list.

Click 'Manage Currency Rates'

The exchange rates are defined under the Rate Types tab, where you can also mention the primary default rate type for transactions.

Rate Types

To upload the daily rates using ADFDI spreadsheet , click on the Create in Spreadsheet button.

Click 'Create in Spreadsheet'

Open the downloaded ADFDI spreadsheet from your local desktop to enter the daily rate details.

ADFDI Spreadsheet

Click on the “Yes” button to log into the ADFDI spreadsheet.

Login ADFDI Spreadsheet

After entering the user credentials same as oracle fusion click on the Sign in button.

Login ADFDI Spreadsheet

Select the From Currency and To Currency from the list of values.

Data Filling ADFDI Spreadsheet

Select the Currency Rate type from the list of value under which rates to be uploaded.

Data Filling ADFDI Spreadsheet

Enter the From Conversion date and To conversion date details along with exchange rate. Two types of actions can be performed such as Insert and delete the exchange rate,

Data Filling ADFDI Spreadsheet

The rows with the triangle-shaped icons are the ones that will be chosen to be uploaded. The Triangle icon appears in the column that has changed next to the row whenever any rows are updated or new details are added.

Data Filling ADFDI Spreadsheet

Click on the OK button to submit the import process.

Upload Daily Exchange rate

A confirmation message is displayed alongwith the number of records updated.

Upload Daily Exchange rate

Navigate to the Scheduled Process, to check whether Import and Calculate Daily rates process is succeeded.

Scheduled Process

Click on the “Search” button after entering all the required search parameters.

Daily Rates

To update the daily rates, click on the rate field.

Daily rates

Under the Historical rates, enter historical rates or amounts for translating actual and budget account balances. You may enter rates for any foreign currency you have enabled.

Historical Rates

Thank you for reviewing and using our guide; we hope you have found it helpful. If you have any questions on the content included in this guide, please contact our Training & Learning team at learn@camptratech.com

Scroll to Top