4 Integration Configurations

New environments are provisioned with the direct database integration method enabled by default between SIOCS and MFCS.

Merchandising System Configuration

Direct database integration method between Merchandising and SIOCS is governed by the following indicators.

  • SIOCS ICL IndicatorFoot 1 – Indicates whether SIOCS gets data from the Merchandising applications through ICL (integration change log) tables. If set to Yes (Y), integration through RIB is disabled and ICL tables are populated. It is defaulted to N. This should be set in sync with the corresponding indicator in SIOCS as part of implementation. There is no user interface option for this and can be managed through a service request to Oracle.

  • Inbound Data History Months – Specifies the number of months the archived inbound transactions will remain in the import history tables and can be set through the System Options screen. All history dated later than this is automatically removed by a batch process.

  • Inbound Data Unprocessed Error Days –Specifies the number of days the inbound data error records are retained in the inbound staging and error logging tables and can be set through the System Options screen.

  • Route External ASN-In to SIOCS – This indicates whether a vendor shipment of purchase orders (that is, ASNIN) from an external system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_ASNIN record for SIOCS to process.

  • Route External ASN-Out to SIOCS – This indicates whether a warehouse to store a shipment of stock orders (that is ASNOUT) from a Warehouse system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_SHIPMENT record for SIOCS to process.

  • Route External Stock Order Status to SIOCS – This indicates whather a Stock Order Status change from a Warehouse system will be passed on to SIOCS from MFCS or not. If set to Y, MFCS will write an ICL_RMS_TRANSFER or ICL_RMS_ALLOC record for SIOCS to process.

SIOCS Configuration

The dataflow from Merchandising into SIOCS is managed by DCS and MPS work types. The appropriate DCS & MPS work types must be enabled by the Retailer. For Work Type details, refer to the "MPS Work Type" and "DCS Work Type" sections in the Oracle® Retail Enterprise Inventory Cloud Service Administration Guide. Dataflow from SIOCS to MFCS occurs directly without the need to manage work types.


Footnote Legend

Footnote 1: SIOCS_ICL_IND in PRODUCT_CONFIG_OPTIONS table