Oracle® Retail Xstore Suite 21.0/Oracle® Retail Merchandising Suite 22.1.201.0 Implementation Guide Release 21.0 F56363-02 |
|
Previous |
Next |
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 (XOCS) |
Oracle Retail Xstore Point of Service | NA |
The integration of the Merchandising Suite and the Xstore Suite consists of two major data flows:
Inbound: Merchandising and pricing information is consumed by Xstore Office where data is loaded into the Xcenter database and files are automatically distributed for data loading into Xstore databases.
Point of Service transactions from Oracle Retail Xstore Point of Service flow to Xstore Office for transformation and distribution 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 inbound Xstore Suite integration from Merchandising is achieved using platform specific integration interfaces. Table 1-1 lists important details about the integration options available to the two Xstore Office V21 deployment topologies: Cloud vs On-Premise. The inbound Xstore Office integration interfaces are:
RMFCS/RPCS web services – Xstore Office requests merchandising and pricing data directly from Merchandising and Pricing Cloud Services
OCDS web services - Xstore Office requests merchandising and pricing data from OCDS, which is a data hub.
RMFCS/RPCS flat file export – Merchandising and pricing data exported from RMFCS and RPCS can be imported into Xstore Office using momzip archive files.
Table 1-1 Inbound Xstore Suite V21 Merchandising Integration Matrix
Xstore Office | Merchandising and Pricing System Data | ||
---|---|---|---|
Direct Web Services | OCDSFoot 1 | Flat FileFoot 2 | |
Cloud |
Yes |
Yes |
Yes |
On-Premise |
No |
Yes |
Yes |
Footnote 1 OCDS is only available with MFCS V19
Footnote 2 RPCS flat file export does not support export of promotions
The outbound Xstore Suite integration to the Merchandising Foundation Cloud Service Sales Audit module is achieved with two options.
Using RTLog flat files generated by RTLog generator. Depending on Xstore suite and Sales Audit deployment topologies, different file delivery options are supported including SFTP, FTS, REST download, or publishing to file system folder.
Using direct Sales Audit REST service integration. RTLog generator is not involved.
Table below lists important details about the integration options available to the two Xstore Office V21 deployment topologies: Cloud vs On-Premise.
Table 1-2 Outbound Xstore Suite V21 Merchandising Integration Matrix
Xstore Office | Merchandising Foundation Cloud Service Sales Audit | ||||
---|---|---|---|---|---|
Sales Audit (REST) | SFTP | FTS | File Download (REST) | Publish to File System Folder | |
Cloud |
YesFoot 1 |
YesFoot 2 |
YesFoot 3 |
Yes |
No |
On-Premise |
No |
No |
No |
No |
Yes |
Footnote 1 XOCS integration with Sales Audit REST API only available in RMFCS V21
Footnote 2 XOCS integration with SFTP is only available in RMFCS V19
Footnote 3 XOCS integration with FTS only available in RMFCS V21
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 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, "Webservice 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.
Appendix B, "Appendix: Flat File Mapping": This appendix describe the flat file mapping.