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

Xstore Office can be integrated with Merchandising directly or through Omnichannel Data Service (OCDS).

When the integration flows through OCDS it 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

Once foundation and price data from Merchandising and Pricing flow to OCDS, Xstore Office will be able to reqeust this data.

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

• Xstore Office communicates directly with Merchandising or through OCDS to request changes to Merchandising and Pricing information. 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": 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, "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.