Period Rates are used in Oracle General Ledger for the revaluation and translation processes.
From release 12, Oracle General Ledger uses daily rates of separate rate types to hold the period end and period average. These rate types are entered against each Ledger so Oracle knows which rates to use.
Period end rates are straightforward; you can use the same rate type as your transactional daily rates. However, period average rates are not calculated for you by Oracle. Oracle expects the period average rates to be already loaded into the rate type you specify. This means calculations outside the system and manually entering the rates into Oracle, every period end. Mistakes when entering period rates lead to incorrect revaluations and translations.
FXLoader provides a fully automated process to calculate the period average rates from the Daily Rates you have already loaded. It then loads these into the rate type you specify, ready for use in revaluation and translation.
Key Features of Period Average Load |
Run from within your existing E-Business Suite environment |
Allows selection of a specific Daily Rate type to use as your source |
Multiple validation options to check that relevant Daily Rates exist – by currency and by date |
Load using Oracle-supported API |
This new rate type can also be used for period-end journals that need to be entered at the period average rate. |
In release 11i of Oracle E-Business Suite, period rates are held separately from daily rates and need to be entered manually in every Set of Books. Period Rates are period end and period average exchange rates used for Oracle General Ledger Revaluation and Translation processes.
Manually typing in period rates is the only method Oracle provides. This only needs to be done once per month, but for organizations with many Set of Books this can represent a large effort. Mistakes when entering period rates lead to incorrect revaluations and translations – the source of which can be tough to track down.
FXLoader provides a fully automated process to calculate period end and period average rates from the Daily Rates you have already loaded. It then loads these into your Sets of Books according to the base currency of each.
Key Features of Period Rates Calculation |
Run from within your existing E-Business Suite environment |
Loads all Sets of Books in a single run, excluding any you flag to be excluded |
Allows selection of a specific Daily Rate type to use as your source |
Multiple validation options to check that relevant Daily Rates exist – by currency and by date |
Option to also populate a separate Daily Rate type with the calculated period average rates |
Copes with multiple period sets if your Sets of Books use different calendars |