Oracle ERP & Retail

​​

Inventory

To ensure precise exchange of inventory information, various configuration options are available. These options form the basis for inventory valuation journals and must be individually tailored to meet legal requirements – both in terms of transmission frequency and granularity. It is crucial that these adjustments are regularly reviewed and updated to ensure compliance with regulations.

​

Exchange Rates (FX) 

Currently, foreign currency management (FX) is carried out in parallel in RMS and the Oracle ERP Cloud, but without automatic reconciliation. To avoid errors in the processing of currency transactions, companies have two options:   
✅ Implementation of a custom process for foreign currency transactions   

✅ Extension of the standard functionality for FX management in both systems 

​

Purchasing

The operational purchasing process is usually covered by RMS, while the non-operational purchasing is managed through the Oracle ERP Cloud. Both systems are optimally designed for their respective tasks. It is crucial that a smooth data integration and a coordinated supplier management are ensured during the design and implementation.

​

Sales

In many RMS-ERP-Cloud implementations, the entire sales process is managed directly in RMS. This is particularly common practice in B2C retail, for example, with orders through a webshop or a point-of-sales (PoS) system. In this scenario, only consolidated revenue data is transferred to the general ledger of the Oracle ERP Cloud – the crucial question here concerns the frequency and granularity of the revenue data transfers. 

Special Requirements in the B2B Environment 

In the B2B sector, it may be necessary to shift accounts receivable management to the ERP Cloud. The main reasons for this are: 

​

✅ A detailed reporting system for analyzing the due dates of receivables   
✅ A structured collection process with comprehensive reminder strategies 

​

 

Impact on System Integration 
 

• Transaction-based Invoice Transfer: 
  Instead of only transmitting consolidated revenues to the general ledger, customer invoices and credits must be transferred to the accounts receivable of the ERP Cloud at the transaction level. 

 

• Synchronization of Master Data: In addition to customer master data, payment terms and other relevant data must also be synchronized. 

 

• Payment Receipts & Open Item Reconciliation: Customer payments must be reconciled with open invoices – depending on the setup, this can range from simple and direct to highly complex, especially when Payment Service Providers (PSP) such as Adyen, Stripe, or PayPal are involved. In this case, PSP reports must be reconciled with both account statement lines and open receivables – ideally fully automated and error-free. 

​