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.
Oracle E-Business Suite
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 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 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 DSS service provides web service access to their currency rates.
XE uses 100+ international sources, filtered for errors, to ensure their currency data reflects accurate global rates.
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.
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
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
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
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
