Table 1-2 Outbound Xstore Suite V21 Merchandising Integration Matrix Xstore Office Merchandising further integrates summarized sales and inventory information from Xstore to other Oracle Retail applications, such as Planning and Analytics. Sales and returns from Xstore are communicated to Merchandising, where these transactions impact inventory. New items, other foundation data, and prices from headquarters are communicated to Xstore. In combination, these data flows represent the round trip of data between the stores and headquarters. 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. 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.

The integration of the Merchandising Suite and the Xstore Suite consists of two major data flows: Oracle Retail Xstore Office Cloud Service (XOCS)

Flat file vs web services