1 Overview

This document describes integration between the Xstore suite of solutions and the Merchandising suite of solutions. For Merchandising, this document covers functionality supported in both the on premise and cloud service versions of the following products:

On Premise Solution	Cloud Service Solution
Oracle Retail Merchandising System (RMS)	Oracle Retail Merchandising Foundation Cloud Service (RMFCS)
Oracle Retail Sales Audit (ReSA)	Oracle Retail Merchandising Foundation Cloud Service (RMFCS)
Oracle Retail Pricing (RP)	Oracle Retail Pricing Cloud Service (RPCS)

For the Xstore Suite, this document covers functionality supported in the following products:

On Premise Solution	Cloud Service Solution
Oracle Retail Xstore Office	Oracle Retail Xstore Office Cloud Service
Oracle Retail Xstore Point of Service	NA

This integration is facilitated in part by the Oracle Retail integration solutions:

• Oracle Retail Integration Cloud Service for SaaS implementations

• Oracle Retail Integration Bus for on premise implementations

  Both the on premise and SaaS versions of the integration solutions include the integration components that are leveraged in the integration: bulk-data integration (BDI), message-based integration (RIB), and a centralized repository of foundation and pricing information that is accessed by service (Omnichannel Data Service or OCDS).

The integration of the Merchandising Suite and the Xstore Suite consists of two major data flows:

• Foundation and price data from Merchandising and Pricing flow into the Omnichannel Data Service (OCDS).

  Xstore Office communicates directly with OCDS to request data-changes reported to OCDS by Merchandising and Pricing. When changes to Merchandising and Pricing data are detected, Xstore .mnt files are automatically generated and distributed for data loading into Xcenter and Xstore databases.

• Point of Service transactions from Oracle Retail Xstore Point of Service to the Merchandising Foundation Cloud Service Sales Audit module.

In combination, these data flows represent the round trip of data between the stores and headquarters. New items, other foundation data, and prices from headquarters are communicated to Xstore. Sales and returns from Xstore are communicated to Merchandising, where these transactions impact inventory. Merchandising further integrates summarized sales and inventory information from Xstore to other Oracle Retail applications, such as Planning and Analytics.

The details of the integration are covered in the remaining sections of this guide:

• Chapter 2, "Data Flow from Merchandising to Xstore using Omnichannel Data Service (OCDS)": This chapter describes the flow of data from the Merchandising applications to Omnichannel Data Service to the Xstore Suite.

• Chapter 3, "Transaction Flow from Xstore to Sales Audit": This chapter describes the flow of transactions from Xstore Point of Service to Sales Audit.

• Chapter 4, "OCDS Integration Configuration": This chapter provides information on the configuration changes that can be made for the integration.

• Chapter 5, "Integration Considerations": This chapter covers functional and technical points about the integration that need to be taken into consideration when implementing the integration.

• Chapter 6, "RTLog Generator On Premise": This chapter covers how to install, deploy, and configure the RTLog Generator application.

• Chapter 7, "RTLog Generator Cloud": This chapter covers the RTLog Generator Cloud.

• Appendix A, "Appendix: Xstore to Sales Audit Mapping Details": This appendix provides tables that describe the mappings.