back to the main page

New, Out-of-the-Box Integration Syncs Merchandising, E-Business Suite Financials

In the first of a series of out-of-the-box integrations that will sync financial and merchandising data, Oracle Retail Merchandising System (RMS) is now fully integrated with Oracle E-Business Suite (EBS) Financials.

"With this integration, retailers can keep key data synchronized between their core business systems and their back-office financials systems while also lowering total cost of ownership," says Tammy Nadzieja, senior director of Oracle Merchandising.

Benefits of the integration are clear: Retailers gain vital insight into their business without having to wrestle with time-consuming and potentially costly integrations.

Share and Share Alike
With the new integration, key data passes seamlessly from EBS Financials to RMS, including General Ledger chart of accounts, vendor and vendor address, payment terms, freight terms, and currency exchange rates.

In return, key data also moves seamlessly from RMS to EBS Financials, including retail stock ledger summary or transaction-level data from RMS to EBS General Ledger, user-defined sales audit totals from ReSA to EBS General Ledger, and vendor payment information from Invoice Matching to both EBS Accounts Payable and EBS General Ledger.

How does it happen? "The Oracle Retail applications place this transactional data on staging tables, and a BPEL process picks up this data and passes it to the appropriate EBS Financials applications," explains Jeff Warren, director of software development, Oracle Merchandising Operations Management.

Toward Master Data Management
The integration with EBS Financials is only the first step in an ambitious plan to build out-of-box integrations with other major financials products, including Oracle's PeopleSoft Enterprise applications, Siebel applications from Oracle, and JD Edwards EnterpriseOne and World applications, as well as third-party offerings, according to Nadzieja.

This, in turn, is part of a much larger strategy to provide master data management (MDM), a vital retail tool that introduces organization data governance (ownership), coordinates the flow of data both internally and externally, and enables lifecycle and workflow processing so downstream transactions function more efficiently.

"Oracle's data hub model allows customers to implement MDM disciplines one subject area at a time, in the context of their enterprise application deployments," says Nadzieja.

Read more about Oracle Retail's next-generation technologies.

back to the top