Period Rates

Release 12 – Period Average Load

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.

The Challenge

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.

The FXLoader Solution

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.

Release 11i – Period Rates Calculation

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.

The Challenge

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.

The FXLoader Solution

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.