Oracle® Retail Store Inventory Operations Cloud Services Implementation Guide Release 19.8 F79093-01 |
|
Previous |
Next |
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
Web Service: Integration with External System for Ticket Printing
Web Service: Integration with External System for Notification Services
The following diagram depicts integrations between EICS and MFCS using Oracle RICS.
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
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): Requires Field Enabled Integration
SIOCS does not use 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 use. SIOCS does have a generic promotion interface for the retailer to integrate promotion price into.
To load third-party data into EICS via BDI, external systems 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.
Customers 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 will 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 schedulerThird 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.
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
Oracle Retail has enabled RFID functionality across various Retail products.
For RFID overview, see Appendix: RFID.
To load third party data into EICS via BDI, external systems 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.
Customers 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.
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 will 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 schedulerThird 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
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.
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
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 batch import warehouse available inventory from third party via BDI.
See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Inventory Available warehouse TX
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.
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
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.
SIOCS is not a package shipping management system. It calls an external shipping-manifest system that acts as a broker for multiple courier entities such as FedEX, UPS, DHL, national mail carriers and so on.
Details of the shipping manifest web service are captured in the WSDL. Details of the data elements are provided in the XSD.
Request Shipping-Manifest-Service jar from Oracle Support.
Please look at all the definitions/wsdl in that JAR and write service as needed. This service will run on a server outside of Oracle network.
Please log a service request on My Oracle Support and provide the following details that are required to be configured by Oracle Cloud Operations.
Server URL to be allow listed.
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.
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.
SIOCS is not a printing system that manages printers & formats. Tickets are sent to an external web service endpoint; that is implemented by any system that needs to receive tickets. The external system is responsible for managing printing.
SIOCS stages the printed tickets in the Message Processing System queue. In order to process the staged tickets, the TicketPrint outbound MPS work type needs to be enabled through the MPS Work Type screen. Please refer to the Oracle® Retail Enterprise Inventory Cloud Service Administration Guide for details on MPS Work Type screen.
The external web service is called tps-TicketPrint and has one operation printTickets.
Details of the ticket printing web service are captured in the WSDL. Details of the ticket data elements are provided in the XSD.
Request tps-TicketPrintService jar from Oracle Support.
Please look at all the definitions/wsdl in that JAR and write service as needed. This service will run on a server outside of Oracle network.
Please make sure outbound TicketPrint MPS work type has been enabled.
Please log a service request on My Oracle Support and provide the following details that are required to be configured by Oracle Cloud Operations.
Server URL to be allow listed.
The URL can also be updated via EICS System Configuration UI using the below configuration.
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.
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.
SIOCS does not provide email integration, but it can be implemented by the external system that this service calls. SIOCS stages the notifications in the Message Processing System queue.
Notifications can be sent to an external web service endpoint that is implemented by any system that needs to receive notifications. The external system is responsible for managing emails. In order to process the staged notifications, the Notification outbound MPS work type needs to be enabled through the MPS Work Type screen. Please refer to the Oracle® Retail Enterprise Inventory Cloud Service Administration Guide for details on MPS Work Type screen.
The external web service is called external-storeextnotificationservice and has one operation createNotification.
Details of the notification web service are captured in the WSDL. Details of the notification data elements are provided in the XSD.
Request sim-external-storeextnotificationservice.jar from Oracle Support.
Please look at all the definitions/wsdl in that JAR and write service as needed. This service will run on a server outside of Oracle network.
Please make sure outbound Notification MPS work type has been enabled.
Please log a service request on My Oracle Support and provide the following details that are required to be configured by Oracle Cloud Operations.
Server URL to be allow listed.
The URL can also be updated via EICS System Configuration UI using the below configuration.
Web Service User alias: notification-user
Credential management: Customer will need to manage the credentials for the external notification system.
ZPL is a proprietary ticket formatting language used for printing to Zebra printers.
ZPL is not entirely an ASCII format and is not readable without tools.
If not using ZPL ticket printing on Zebra printers, then usage of ZPL is not recommended.
If using ZPL with ZPL printers, SIOCS allows for the placement of tags within the ZPL design (managed by ZPL tools).
SIOCS will then replace those tags with the correct data before sending the ticket information to the web service endpoint.
ZPL files and formats are created and managed by tools and software outside of SIOCS. Files are uploaded into SIOCS.
Information captured in printer administration is sent with the ticket information, such as printer name and address.
The custom development of the printing system (or middleware system designed to speak to a printing solution) must use the printer and ticket information to determine how to print.
Ticket information can be used to determine format of ticket to print, but such tasks as matching the ticket type information to a template managed by the implementing system.
Once a template in the middleware system is identified, the middleware system should use ticket information to populate the template and print the ticket. SIOCS does not manage printing templates.
Printer information can be used to determine which printer it should be sent to.
Printing templates are created and manages by tools and software outside of SIOCS as part of a custom or middleware product.
The Oracle Retail Integration Bus (RIB) is a fully distributed integration infrastructure that implements messaging using Asynchronous JMS Publish/Subscribe Fire-and-Forget model.
The concept of message-bus is that one product broadcasts information and each product or cloud service only subscribes to those message families/payloads that they are interested in. Everything else is ignored.
To process all messages intended for ordering systems, pricing systems, or any other external systems would require massive processing of mapping, then writing to the database, and then reading messages that are not intended for processing in our system in order to discard them.
To avoid all the processing and overhead, messages not intended for SIOCS are simply dropped at the point of receiving them from the RIB.
When an entire family or message type is not used or desired in SIOCS, then it is not subscribing to and does not arrive at SIOCS.
The message type and payload have no injector that places the RIB payload into the MPS staged message processing workflow in SIOCS.
In the case of some message families or types, a brief look at the internal information of the message may also determine, it is not meant for SIOCS.
SIOCS does not process non-stockholding stores (stores with no inventory). So, if a payload arrives for a message family and type we support, but the payload contains an internal attribute, usually labeled "stockholding_ind", that is set to "N", the payload is dropped as it is not intended for the SIOCS system.
SIOCS does not process virtual stores so limited itself by store type. If the payload contains a store type attribute, then SIOCS only processes COMPANY ("C") stores and FRANCHISE ("F") stores.
When dealing with quantities, a quantity of 0 primarily means a cancellation or removal of that item or detail from a transaction, and so it is deleted. There may be exception to this in certain circumstances.
Errors that occur within the RIB through injection in MPS are logged and managed within the RIB.
Errors that occur within MPS staged messages within SIOCS are logged and can be seen and managed with MPS management workflow.
Messages that are successfully processed, including successfully being ignored as not relevant to the store, do not log any information.
In the case of transaction data, in some cases if the transaction is actively being processed by a user or business functionality in the store, it may have already passed a state where it can be modified or canceled.
The following table contains a list of message families and types that SIOCS subscribes to (incoming) or broadcasts (publishes out) to other systems.
It indicates the family name, message type, payloads used within the family, whether SIOCS publishes or subscribes to it, and whether it is part of the initial data seeding.
Message type suffixes indicates intent of the payload: Cre means create information, Mod means modify information, and Del means cancel or delete information.
Table 14-5 Message Family/Type
Message Family | Message Type | Payload | Publish/ Subscribe | Seeded | SIOCS Data |
---|---|---|---|---|---|
ASNIn |
ASNInCre ASNInMod |
ASNInDesc |
Subscribe |
No |
Store Delivery |
ASNOut |
ASNOutCre |
ASNOutDesc |
Publish |
No |
Store Shipment |
ClrPrcChg |
ClrPrcChgCre ClrPrcChgMod ClrPrcChgDel |
ClrPrcChgDesc ClrPrcChgRef ClrPrcChgDtlRef |
Subscribe |
No |
Clearance Price Change |
CoInvAvail |
COInvAvailMod |
COInvAvailDesc |
Publish |
No |
Customer Order Store Inventory Shift Notification |
Diffs |
DiffCre DiffDel DiffMod |
DiffDesc DiffRef |
Subscribe |
Yes |
Differentiators |
DSDReceipt |
DSDReceiptCre DSDReceiptMod |
DSDReceiptDesc |
Publish |
No |
Non-PO DSD Receipt |
FulfilOrd |
FulfilOrdStDlvCre FulfilOrdReqDel FulfilOrdApprDel |
FulfilOrdDesc |
Subscribe |
No |
Fulfillment Orders |
FulfilOrdCfm |
FulfilOrdCfmCre |
FulfilOrdCfmDesc |
Publish |
No |
Fulfillment Order Confirm |
FulfilOrdCfmCnc |
FulfilOrdCfmCncCre |
FulfilOrdRef |
Publish |
No |
Fulfillment Order Cancel |
InvAdjust |
InvAdjustCre |
InvAdjustDesc |
Publish, Subscribe |
No |
Stock Movement Notification |
InvReq |
InvReqCre |
InvReqDesc |
Publish |
No |
Store Order/Item Request |
ItemLoc |
ItemLocCre ItemLocDel ItemLocMod ItemLocReplMod |
ItemLocDesc |
Subscribe |
Yes |
Item Location Item Replenishment |
Items |
ItemBOMCre ItemBOMDel ItemBOMMod ItemCre ItemDel ItemHdrMod ItemImageCre ItemImageMod ItemImageDel ItemUPCCre ItemUPCDel ItemUPCMod |
ItemBOMDesc ItemDesc ItemHdrDesc ISCDimDesc ItemImageDesc ItemTcktDesc ItemUPCDesc |
Subscribe |
Yes |
Item Item Details Item UPC Item Image |
Items |
RelItemHeadCre RelItemHeadMod RelItemHeadDel RelItemDetCre RelItemDetDel RelItemDetMod |
RelatedItemDesc |
Subscribe |
Yes |
Related Items |
Items |
ItemSupCre ItemSupDel ItemSupMod ItemSupCtyCre ItemSupCtyDel ItemSupCtyMod ISCDimCre ISCDimMod ISCDimDel ISCMfrCre ISCMfrDel ISCMfrMod |
ItemSupCtyDesc ItemSupCtyMfrDesc ItemSupDesc |
Subscribe |
Yes |
Supplier Items Supplier Manufacturer Supplier Country |
Items |
ItemUDALOVCre ItemUDALOVMod ItemUDALOVDel ItemUDAFFCre ItemUDAFFMod ItemUDAFFDel ItemUDADateCre ItemUDADateMod ItemUDADateDel |
ItemUDADateDesc ItemUDAFFDesc ItemUDALOVDesc |
Subscribe |
Yes |
Item User Defined Attributes |
MerchHier |
ClassCre ClassMod ClassDel DeptCre DeptMod DeptDel SubclassCre SubclassMod SubclassDel |
MrchHrClsDesc MrchHrDeptDesc MrchHrSclsDesc |
Subscribe |
Yes |
Department Class Subclass |
Order |
POCre PODel PODtlCre PODtlDel PODtlMod POHdrMod |
PODesc PORef |
Subscribe |
No |
Purchase Order |
Partner |
PartnerCre PartnerDel PartnerMod PartnerDtlCre PartnerDtlDel PartnerDtlMod |
PartnerDesc PartnerOUDesc PartnerRef |
Subscribe |
Yes |
Finishers |
PrmPrcChg |
MultiBuyPromoCre MultiBuyPromoMod MultiBuyPromoDel PrmCnlItemLocCre |
PromotionDesc |
Subscribe |
No |
Promotions |
RcvUnitAdj |
RcvUnitAdjCre RcvUnitAdjMod |
RcvUnitAdjDesc |
Subscribe |
No |
Adjusts Supplier Deliveries |
Receiving |
ReceiptCre ReceiptOrdCre |
ReceiptDesc |
Publish |
No |
Transfer Receipt, Purchase Order Receipt, Receipt with Customer Order |
RegPrcChg |
RegPrcChgCre RegPrcChgMod RegPrcChgDel |
RegPrcChgDesc RegPrcChgDtl |
Subscribe |
No |
Regular Price Change |
RTV |
RTVCre |
RTVDesc |
Publish, Subscribe |
No |
Warehouse Return |
RTVReq |
RTVReqCre RTVReqMod RTVReqDel RTVReqDtlCre RTVReqDtlDel RTVReqDtlMod |
RTVReqDesc RTVReqRef |
Subscribe |
No |
Supplier Return |
SeedData |
DiffTypeCre DiffTypeDel DiffTypeMod |
DiffTypeDesc DiffTypeRef |
Subscribe |
Yes |
Differentiator Types |
ShipInfo |
ShipInfoCre |
ShipInfoDesc |
Publish |
No |
Pre-Shipment Notification |
SOStatus |
SOStatusCre |
SOStatusDesc |
Publish, Subscribe |
No |
Transfers Shipments |
StkCountSch |
StkCountSchCre StkCountSchMod StkCountSchDel StkCountSchDtlDel |
StkCountSchDesc |
Publish |
No |
Stock Count Schedule |
StockOrder |
SOCre SODtlCre SODtlDel SODtlMod SOHdrDel SOHdrMod |
SODesc SORef |
Subscribe |
No |
Transfer Allocation |
Stores |
StoreCre StoreDel StoreMod StoreDtlCre StoreDtlDel StoreDtlMod |
StoreDesc StoreRef |
Subscribe |
Yes |
Store |
UDAs |
UDAHdrCre UDAHdrMod UDAHdrDel UDAValCre UDAValMod UDAValDel |
UDADesc UDARef UDAValDesc UDAValRef |
Subscribe |
No |
User Defined Attributes |
Vendor |
VendorAddrCre VendorAddrDel VendorAddrMod VendorCre VendorDel VendorHdrMod VendorOUCre VendorOUDel |
VendorAddrDesc VendorAddrRef VendorDesc VendorRef |
Subscribe |
Yes |
Suppliers |
WH |
WHCre WHDel WHMod |
WHDesc WHRef |
Subscribe |
Yes |
Warehouse |
When Xstore is sold with SIOCS then SIOCS handles inventory updates.
Xstore (on-premise) is integrated with SIOCS out of the box. Xstore point of sale terminals call the following SIOCS web-services.
/StoreInventoryBean/StoreInventoryService
/StoreInventoryUinBean/StoreInventoryUinService
/POSTransactionBean/POSTransactionService
Below interactions are initiated from POS terminal that reach out to SIOCS web services to fulfill various requirements.
Within Item Lookup, all inventory stock information for the searched item is retrieved from SIOCS. StoreInventoryService > lookupInventoryInStore
Inventory Locator makes a call to SIOCS to retrieve available inventory levels for items across stores. StoreInventoryService > lookupAvailableInventory
In back office Order Maintenance, the Check Inventory feature retrieves the available quantity from SIOCS. StoreInventoryService > lookupAvailableInventory
When purchasing or ordering an item, a call to check if the item is available in the store is made. Note that this is disabled by default. StoreInventoryService > lookupAvailableInventory
When purchasing or returning a serialized item, a call is made to validate the serial number in SIOCS. Note that this validation is configurable and that the default setting for this configuration is not to validate. StoreInventoryUinService > readUINDetail
During POS transaction completion, records of changes to inventory that occurred within the transaction are sent to SIOCS to update inventory levels there. POSTransactionService > ProcessPOSTransactions
Information related to the above web services and its implementation can be found in Oracle® Retail Enterprise Inventory Cloud Service Administration Guide under the section titled Available Web Services.
Table 14-6 Xstore Timeout and Retry Configurations
Service | Connect Timeout Default | Connect Timeout Action | Read Timeout Default | Read Timeout Action |
---|---|---|---|---|
StoreInventoryService |
30 Seconds |
Return Error |
30 Seconds |
Return Error |
StoreInventoryUinService |
30 Seconds |
Return Error |
30 Seconds |
Return Error |
POSTransactionService |
30 Seconds |
Retry after 15 minutes |
30 Seconds |
Retry after 15 minutes |
See Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Integration chapter.