GL Daily Rates Upload creates and updates GL daily currency conversion rates from Excel. You enter the from and to currency, the conversion type, a date range and the rate, and the upload stages the rows and runs Oracle’s standard Daily Rates Import and Calculation program to write them into General Ledger.
When to use it
- Load a batch of new daily exchange rates for one or many currency pairs.
- Apply a single rate across a date range instead of entering each day.
- Update existing rates – download them, edit the rate, and re-upload.
- Maintain rates for several conversion types in one spreadsheet.
Before you start
- Blitz Report is installed and you are signed in to a General Ledger responsibility that can maintain daily rates.
- The conversion (rate) type and both currencies already exist and are enabled.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open GL Daily Rates Upload, choose an Upload Mode, and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create (empty template) or Create, Update (existing rates downloaded for editing). Default is Create. |
| Default User Conversion Type | Pre-fills the Conversion Type on new rows. |
| From Currency / To Currency | Restrict which existing rates are downloaded. |
| Conversion Type | Restrict the download to one conversion type. |
| From Date / To Date | Restrict the download to a date range. |
For a Create, Update download, specify a From and/or To Currency and a From/To date range. Run the upload to download and open the Excel file.
Step 2 – Enter the rates
On each row enter the From Currency, To Currency, User Conversion Type, the From Conversion Date and To Conversion Date the rate applies across, and the Conversion Rate. Enter an Inverse Conversion Rate only when your instance does not enforce the inverse relationship – otherwise it is ignored and computed for you.
Step 3 – Validate and Save
Click Validate and Save. This checks for missing required values and runs any extra validation the upload defines, then saves the file. Correct anything it flags before continuing.
Step 4 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which stages your rows and runs Oracle’s Daily Rates Import and Calculation program to write the rates into General Ledger. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Daily conversion rates created or updated in General Ledger.
- A result report listing every row with a status (success or error) and a message.
Common questions
Does it create or update?
Both. New currency / type / date combinations are created; existing ones are updated. To change existing rates, download them in Create, Update mode and re-upload the edited values.
How does the rate get into GL?
The upload stages each row, then runs Oracle’s standard Daily Rates Import and Calculation program, which does the final validation and writes the rates. Upload success therefore depends on that program completing normally.
Why was my Inverse Conversion Rate ignored?
Because your instance enforces the inverse relationship during entry – the inverse is then computed for you and any value you enter is discarded. Enter an inverse rate only when that setting is off.
Can one rate cover several days?
Yes. Set the From Conversion Date and To Conversion Date and the rate applies across that range.
Why can’t I pick a currency I expected?
The currency must be enabled and active; statistical and EMU-derived currencies are excluded, and the To Currency cannot equal the From Currency.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Daily Rates Import and Calculation not submitted | The import request could not be submitted. | Check the reason shown and your permissions to run the program. |
| Daily Rates Import and Calculation completed in error | The import program ran but ended in error or warning. | Open the named Oracle request log for the specific data errors, correct the rows and re-upload. |
| Invalid, disabled or statistical currency | A currency on the row is not valid for daily rates. | Use an enabled, active currency (not statistical or EMU-derived). |
| Negative conversion rate | The Conversion Rate (or Inverse) is negative. | Enter a positive rate. |
| Date range too large / duplicate rows | The date range is too wide, or the same currency/type/date appears twice. | Narrow the range or remove the duplicate rows. |