Loading Oracle ERP Cloud Exchange (FX) Rates to Sales Planning Cloud

In Data Integration, customers can now extract exchange rates (FX rates) from the Oracle ERP Cloud using an ERP Cloud FX Rate adapter. The adapter is used as a data source in Data Integration. The adapter enables customers to select daily conversion rates for specific combinations of foreign currency, dates, and conversion rate types. This feature is only available for the standard load method.

The ERP FX Rate adapter supports period mapping requirements for the FX rate. The source data from the Oracle ERP Cloud is provided by the conversion date. Date-based FX Rate data is converted to Sales Planning periods so it can be easily mapped and loaded to Sales Planning Cloud applications. 

Customers who want to use the new adapter are required to be on Oracle Fusion Cloud Financials Update24B in order to extract FX rates from the Oracle ERP Cloud.

Business Benefit: The ERP Cloud FX Rate Adapter is a purpose-built adapter, which enables customers to pull FX rates from Oracle ERP Cloud without having to build custom BI Publisher reports. Using this feature, organizations have ready access to exchange rate values when determining revenue allocation for currency-denominated revenue streams.

Key Resources