1 Overview

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

Foundation and price data from Oracle Retail Merchandising System (RMS) and Oracle Retail Price Management (RPM) to Oracle Retail Xcenter and Xstore Office
Point of Service transactions from Oracle Retail Xstore Point of Service to Oracle Retail Sales Audit (ReSA)

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 the Xstore applications.
Chapter 3, "Transaction Flow from Xstore to ReSA": This chapter describes the flow of transactions from Xstore Point of Service to ReSA.
Chapter 4, "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": This chapter covers how to install, deploy, and configure the RTLog Generator application.
Chapter 7, "Existing Functionality Gaps": This chapter describes any functional gaps that exist between Xstore and the Merchandising applications.
Appendix A, "Appendix: POSLog to RTLog Mapping Details": This appendix provides tables that describe the mappings.
Appendix B, "Appendix: Flat File Mapping": This appendix provides tables that describe the mapping from the RMS and RPM flat file format to the Xstore database format.