14 Integrations

This chapter describes the integration setup within EICS to Integrate with other systems.

For completed integration interfaces, see Oracle Retail Enterprise Inventory Cloud Service Administration Guide - Integration chapter.

Foundation Data Integration with Foundation Data Cloud Service

The following diagram depicts integrations between EICS and MFCS using Oracle RICS.

Figure 14-1 Integrations between EICS and MFCS

For a complete list of integration details, see:

Oracle Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter
Oracle Retail Enterprise Integration Overview Guide
Oracle Retail Bulk Data Integration Implementation Guide
Oracle Retail Enterprise Integration Guide

Pricing Integration with Retail Pricing Cloud Service

Clearance Transaction Import

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch Chapter: Clearance Transaction Import

Price Change Transaction Import

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch Chapter: Price Change Transaction Import

Promotion Offer Import (N/A): Require Filed Enabled Integration

SIOCS does not consuming Oracle Retail Pricing Cloud Service Interface PromotionOffer_Tx, It requires field enabled integration. At this point, the pricing service does not post promotion price by item/date, so there is nothing for SIOCS to consume. SIOCS does have a generic promotion interface for the retailer to integrate promotion price into.

Pricing Integration with 3rd Party

BDI Implementation Considerations

To load third party data into EICS via BDI, external system need to provide data sourcing implementations.

There are two approaches for data sourcing implementations.

BDI Ext-EdgeApp Approach:

With this approach, the BDI Ext Process Flow will move the data from sourcing system to destination system's application table. BDI process flow provides BDI job scheduling, end to end data transportation from sourcing system's database table into destination application's tables.

Customer need to implement the BDI Ext-EdgeApp to move data into the BDI outbound interface table.

BDI Process Flow: ExtPrice_Tx_ProcessFlow_From_EXTERNAL

See Oracle Retail Enterprise Integration Overview Guide: BDI Third Party Integrations

BDI CLI File transmitter Approach:

BDI CLI File Transmitter is a client command line tool, is applicable for smaller data file size which does not require concurrent processing.

BDI CLI file transmitter only transport data files from sourcing systems to destination system's interface tables. It does not provide end to end data transportation. If you choose BDI CLI File transmitter for load third party data into EICS application table, it would require three steps:

Download BDI CLI File Transmitter and install on customer's system.
Run BDI CLI Transmitter batch to load data file from sourcing system into destination system's interface table.
Once the data are loaded into receiver app's inbound interface tables, EICS's importer job will move the data from inbound interface table into EICS app tables.

Note:

By default, batch scheduler Third Party Price Import in EICS is disabled; this job should only be enabled if you choose to use BDI CLI File transmitter for data sourcing provider.

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter.

Pricing Imports with On-premise RPM

Price Change Import (On Premise RPM):

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch Chapter: Price Change Import

Clearance Price Change Import (On Premise RPM):

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch Chapter: Clearance Price Change Import

Promotion Price Change Import (On Premise RPM):

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch Chapter: Promotion Price Change Import

RFID Integrations

Oracle Retail has enabled RFID functionality across various Retail products.

For RFID overview, see Appendix: RFID.

RFID BDI Implementation Considerations

To load third party data into EICS via BDI, external system need to provide data sourcing implementations.

There are two approaches for data sourcing implementations.

BDI Ext-EdgeApp Approach:

Customer need to implement the BDI Ext-EdgeApp to move data into the BDI outbound interface table.

BDI Process Flow: ExtRfid_Tx_ProcessFlow_From_EXTERNAL

See Oracle Retail Enterprise Integration Overview Guide: BDI Third Party Integrations

BDI CLI File transmitter Approach:

BDI CLI File Transmitter is a client command line tool, is applicable for smaller data file size which does not require concurrent processing.

Download BDI CLI File Transmitter and install on customer's system.
Run BDI CLI Transmitter batch to load data file from sourcing system into destination system's interface table.
Once the data are loaded into receiver app's inbound interface tables, EICS's importer job will move the data from inbound interface table into EICS app tables.

Note:

By default, batch scheduler Third Party RFID Import in EICS is disabled; this job should only be enabled if you choose to use BDI CLI File transmitter for data sourcing provider.

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter.

Stock Count Export Integration with MFCS

Stock Count Export

When a Unit Amount stock count is authorized, a Unit and Amount Stock Counts Export file is generated.

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Appendix: Unit and Amount Stock Counts Export.

Sale Data Integration with POS and ReSA

POS Transaction Import Batch

Note:

Oracle Retail Xstore POS does not use this batch to integrate with SIOCS.

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch chapter
Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter

Retail Sale Audit Import Batch

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Batch chapter
Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter

Stock Count Import with 3rd Party

Third Party Stock Count Import

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Third Party Stock Count Import
Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Appendix: Batch File Layout

Inventory Available Warehouse TX with 3rd Party

Inventory Available warehouse TX batch import warehouse available inventory from third party via BDI.

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Inventory Available warehouse TX

Web Service: Integration with Generic Order Mgmt System

See:

The Oracle Retail Enterprise Integration Overview Guide - Customer Address

Web Service URL:

System Integrator provides the external Web Service URL. This URL is taken as input by the EICS installer to update system configuration entry in the database.

The URL can also be updated via EICS System Configuration UI using the below configuration.

Table 14-1 System Configuration Entries

Database CONFIG_SYSTEMName	System Configuration UI Display Name
integration.fulfilord.wsdl.url	Fulfillment Order Web Service URL
integration.fulfilordaddr.wsdl.url	Fulfillment Order Address Web Service URL

Web Service User alias: oms-user
OMS is an external system called through RSB so the customer will need to manage those credentials. EICS chef scripts takes the provided input to add to EICS credential stores

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration Chapter: Web Service
The Oracle Retail Enterprise Integration Overview Guide

Web Service: Integration with Manifest System

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide - Integrate with Manifest System
Web Service URL:

System Integrator provides the external Web Service URL. This URL is taken as input by the EICS installer to update system configuration entry in the database.

The URL can also be updated via EICS System Configuration UI using the below configuration.

Table 14-2 System Configuration

Database CONFIG_SYSTEMName System Configuration UI Display Name

integration.manifest.wsdl.url

Manifest Web Service URL
Web Service User alias: manifest-user
Credential management: Manifest is an external system called through RSB so the customer will need to manage those credentials. EICS installation takes the provided input to add to EICS credential stores

Database CONFIG_SYSTEMName	System Configuration UI Display Name
integration.manifest.wsdl.url	Manifest Web Service URL

Web Service: Integration with External System for Ticket Printing

See:

Oracle® Retail Enterprise Inventory Cloud Service Administration Guide - Ticket Print
Web Service URL:

System Integrator provides the external Web Service URL. This URL is taken as input by the EICS installer to update system configuration entry in the database.

The URL can also be updated via EICS System Configuration UI using the below configuration.

Table 14-3 System Configuration

Database CONFIG_SYSTEMName System Configuration UI Display Name

iintegration.ticket.wsdl.url

Ticket Print Web Service URL
Web Service User alias: ticket-user
Credential management: Customer will need to manage the credentials for the external printing system. EICS installation takes the provided input to add to EICS credential stores

Database CONFIG_SYSTEMName	System Configuration UI Display Name
iintegration.ticket.wsdl.url	Ticket Print Web Service URL

Other Integration Interfaces

See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter.