Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
1
Introduction
This document provides an overview of the integration between Oracle Retail Merchandising1 and Oracle Retail Store Inventory Operations Cloud Service (SIOCS). Merchandising and SIOCS get installed on separate schema on the same database and have direct database integration. This direct method does not require integration middleware and covers most of the integration points between Merchandising and SIOCS.
For data flowing from Merchandising to SIOCS, Merchandising has database views for each data entity which are queried periodically by SIOCS for new foundation data, new transactional data and changes to foundation and transactional data. Merchandising has change log tables for each entity which is used by SIOCS to identify and query changed data points.
For transactions owned by SIOCS and required by Merchandising, SIOCS writes new and changed transactions into respective staging tables which are consumed by Merchandising through periodic polling.
Merchandising and SIOCS Integrations
| From Merchandising to SIOCS | |
|---|---|
| Address | Price History |
| Allocations | Purchase Orders |
| ASNs 1 | Receiver Unit Adjustments |
| Codes | Return to Vendor Requests |
| Delivery Slots | Stores |
| Differentiator Types | Store Inventory |
| Differentiators | Transfers |
| Item Locations | UOM Classes and Conversion |
| Items | User Defned Attributes |
| Merchandise Hierarchy | Vendors |
| Partners | Warehouses |
| Purchase Order Shipment | Stock Order Status |
| Warehouse to Store Shipment |
1 Merchandising publishes Advanced Shipping Notification (ASN) for only shipments shipped using Merchandising screens.
| From Pricing to SIOCS | |
|---|---|
| Clearances and Clearance Resets | Price Changes |
1 Oracle Retail Merchandising refers to the group of cloud services consisting of Retail Merchandising Foundation Cloud Service (RMFCS), Sales Audit, Retail Pricing Cloud Service (RPCS), Retail Invoice Match Cloud Service (ReIMCS) and Allocation Cloud Service.
Implementation Guide G56162-01 Copyright© 2026, Oracle and/or its affiliates.
From Sales Audit to SIOCS
Audit Revision to Sales/Return Transaction
From SIOCS to Merchandising
| Direct Store Delivery Receipts | Return to Vendor |
|---|---|
| Fiscal Documents | Stock Order Receipt |
| Inventory Adjustments | Stock Order Status |
| Inventory Requests | Stock Count Schedule |
| Outbound ASNs | Stock Count Results |
| Purchase Order Receipts | Store Order Review |
Implementation Guide G56162-01 Copyright© 2026, Oracle and/or its affiliates.