Oracle E-Business Suite

FXLoader for Oracle E-Business Suite – Overview

FXLoader for Oracle E-Business Suite provides facilities for managing exchange rates in Oracle – loading daily rates, calculating period rates and exchange rate inquiry/reporting.

fx-loader-ebusiness-4

Oracle E-Business Suite Rates Data Source

Currency exchange rates are necessary for dealing with foreign currency transactions in any area of Oracle E-Business Suite.
Daily Rates can be loaded from OANDA, Xignite, Reuters, XE and 40+ Central Banks, including The European Central Bank. .

oanda-logo

OANDA is one of the most trusted sources of currency data. FXLoader are OANDA partners and provide their exchange rates service as part of the FXLoader subscription. The service provides daily market rates to every tradable currency, and central bank rates with their Advanced Plan.

xignite-logo

Xignite provide the Market Data Cloud on their enterprise-class delivery platform. Their currency rates service provides market rates to every tradable currency, plus rates published by a number of central banks around the world. FXLoader are Xignite partners, enabling us to provide their service as part of our subscription.

reuters-logo

Reuters DSS service provides web service access to their currency rates.

xe-logo-2

XE uses 100+ international sources, filtered for errors, to ensure their currency data reflects accurate global rates.

european-central-bank-logo

The ECB publishes EUR rates to approximately 33 major currencies. FXLoader can triangulate these rates to provide rates based on USD, or any other currency.

central-banks-logo

FXLoader provides official central bank rates via Xignite, OANDA and direct within FXLoader. These are needed for statutory reporting in some countries.

FXLoader Installation & Add-ons

In addition to the core Daily Rates product, we also offer add-ons for Period Average Rates, Reports and a Web Inquiry Page. The products can be licensed separately or together.

All products are installed in your existing Oracle E-Business Suite instance under a custom application, following Oracle’s standards for third-party extensions.

A single installation script is provided for each product to automate the install. You will also receive a Reference Manual explaining the configurable parameters and a User Guide.

Brief demo of FXLoader for Oracle E-Business Suite – Daily Rates Load from OANDA

System Requirements

Oracle E-Business Suite releases from: 11i (11.5.x) to R12 (12.0.x, 12.1.x and 12.2.x)

Exchange rate reports require XML Publisher, generally available from 11.5.10 onwards.

Daily Rates for E-Business Suite

Most organizations using Oracle E-Business Suite require some multi-currency functionality. Oracle converts all transactions in foreign currency to your functional currency using a defined exchange rate – supplier and customer invoices and payments, GL journals, purchase orders, sales orders, etc.

These exchange rates are known as Daily Rates in Oracle and are shared by all modules of E-Business Suite.

The Challenge

Oracle provides a screen to manually enter Daily Rates, but this can be time consuming and prone to error as with any manual process. The impact on the business can be significant:

If rates are not entered, foreign currency transactions cannot be processed for that date

If rates are entered incorrectly, your account balances will be wrong but the problem may not become evident until weeks or months later.

The FXLoader Solution

FXLoader provides a fully automated interface to load rates from a choice of sources – OANDA, Xignite, Reuters, XE, ECB, UK HMRC, Bank of England and 40+ Central Banks – directly into Oracle EBS. Set it up to run on a schedule you choose and it will load rates in the background – no user action or checking is required.

Rates are loaded using Oracle-supported APIs and extension standards.

Key Features of Daily Rates Load

Scheduled within your existing E-Business Suite environment

Handles communication with rates service directly from your database

Full validation and load using Oracle-supported API

Load rates daily or monthly between all currencies you need

Option to triangulate from a base currency or load rates for all combinations

Uses the most reliable services providing trusted exchange rates

Robust failure handling including automatic re-tries

fx-loader-ebusiness-daily-rates-2

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

fx-loader-ebusiness-period-rates

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

fx-loader-ebusiness-period-rates-calculation

Exchange Rates Web Page

After loading your currency rates, you may want to make those same rates available to users or other applications.

FXLoader provides an inquiry web page to display your Daily Rates. This sits within Oracle E-Business Suite, but does not require the user to login, so can be made available to anyone in your organization.

Key Features of Daily Rates Web Page

Available to anyone in your organization

Built using E-Business Suite design and extension standards

Allows export to Excel

Query by rate type and from/to date, with optional restriction by from/to currency

Exchange Rates Reports

FXLoader also provides reports from Oracle E-Business Suite for Daily Rates and, prior to Release 12, Period Rates. These use Oracle XML Publisher (BI Publisher) to produce reports in Excel format.

Key Features of Daily Rates Report

Outputs the Daily Rates you have downloaded from OANDA or ECB

Designed to output in Excel format, but PDF can also be selected

Reports by rate type and date, with optional restriction by from currency

Provides a cross-tab output and a simple table format

XML Publisher Template is available to modify the format if desired

Key Features of Period Rates Report

Output the Period Rates you have calculated or entered manually

Designed to output in Excel format, but PDF can also be selected

Reports by period and base (functional) currency

Provides a cross-tab output and a simple table format, for both period end and period average rates

XML Publisher Template is available to modify the format if desired

sample spreadsheet reports

sample spreadsheet reports
sample spreadsheet reports

Request a call back or 30 day trial