Automate load of period end and period average rates into EBS
57
page,page-id-57,page-child,parent-pageid-16,page-template-default,ajax_fade,page_not_loaded,,qode-title-hidden,qode-child-theme-ver-1.0.0,qode-theme-ver-11.0,qode-theme-bridge,wpb-js-composer js-comp-ver-5.1.1,vc_responsive

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.

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.

diagram-02


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.

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

diagram-01