Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation at the Oracle Help Center
• Conventions

1 Technical Architecture

• Multiple Products
• Logical Model
• SaaS Deployment
• Cloud Deployment
  • EICS Client
  • SOCS Mobile Client
  • Web Services
  • WTSS / IDCS or OCI IAM
  • EICS Application Server(s)
  • OBIEE Server
  • SFTP Server
  • Oracle DB Server (DBaaS)
  • Client-Server Communication
• Integration
  • Oracle Retail Integration Bus (RIB)
  • SOAP Web Services
  • File-Based
• Deployment with Other Products
• Deployment - Performance: Bandwidth, Scaling
  • Bandwidth Requirements for Browser Clients
  • Network Latency Constraints
  • Application Server Clustering
  • Database Clustering with RAC

2 Data Seeding

• What is Data Seeding?
• Overview of Data Seeding Process
• Pre-requisites
• Configure EICS for Data Seeding
  • Security Settings
  • Configuration Parameters
  • Steps to Enable Data Seeding in SIOCS UI
  • Steps to Manual Control Importers
  • Optional Steps Prior Initial Seeding
• Run BDI Data Seeding
  • BDI Process Flow Admin Console
    • Extractor
    • Downloader
    • Uploader/Receiver
    • Importer
    • Import Staging Data to Application Tables
    • Re-running EICS Importer Data Loads
  • BDI-Based Data Seeding Post-Load Processes

3 Reporting

• EICS Reporting Framework
  • Report Service
  • Security Considerations
  • BI Publisher Server
• Report URL Location
• Previewing a Report
• EICS Operational Reports

4 Internationalization

• Supported Locales
• SOCS Client Translations
• EICS Client Translations
• EICS Server Translations
• Translation Topics
• Translation Keys
• Translation Setup Screen
  • Bundle Selection Dialog
  • Translation Setup Screen
• Translation File Upload
• Report Translations

5 Batches

• Batch Overview
• Batch Admin Users
• Batch Configuration
• Operational Batches
  • Archive Activity History
  • Archive Dump
  • Archive Item Uin History
  • Archive RFID History
  • Archive Store Item Stock History
  • Archive Ticket History
  • Auto Replenish Capacity
  • Auto Ticket Generate
  • Auto Ticket Print
  • Cleanup Batch Directories
  • Cleanup Shelf Replenishment
  • DSD Receiving Closure
  • Extract Subscription Usage
  • Fulfillment Order Pick Reminders
  • Fulfillment Order Reminders
  • Generate Problem Line Stock Count
  • Generate Unit Amount Stock Count
  • Generate Unit Stock Count
  • Inventory Extract File SFTP Push
  • Item Basket Maintenance
  • Item Price to History
  • Product Group Schedule Clean up
  • Return Not After Date Alert
  • Stock Count Authorize Recovery
  • Stock Count Export
  • Stock Count Export File SFTP Push
  • Stock Count Unit and Amount Snapshots
  • Store Order Auto Approve
  • Store Order Auto Cancel
  • Store Order Auto Generate
  • Transfer Close
  • Transfer Delivery Auto Receive
  • Transfer Delivery Close
  • Transfer Not After Date Alert Batch
  • Transfers Overdue
  • Vendor Return Closure
• BDI-Based Batches
  • Clearance Transaction Import
  • Price Change Transaction Import
  • Rfid Transaction Import
  • Third Party Pricing Import
  • Warehouse Avail Inventory Import
• SFTP File-Based Batches
  • Clearance Price Change Import (with On-premise RPM)
  • High Level Batch File Process Overview
  • Initial Inventory Import
  • Inventory Extract
  • Pos Transaction Import
  • Promotion Price Change Import (with On-premise RPM)
  • Regular Price Change Import (with On-premise RPM)
  • Retail Sale Audit Import
  • SFTP Nightly Batch File Uploads
    • Adding Authorized Keys
    • Login to WinSCP
    • Uploading a Batch File
    • Export File Downloads
  • Store Sequence Import
  • Third Party Stock Count Import
  • Warehouse Item Stock Import
• Purge Batches
  • Purge Adhoc Stock Count
  • Purge Areas
  • Purge Batch Log
  • Purge Closed Transfers
  • Purge Completed UINs
  • Purge DSD and Purchase Orders
  • Purge Customer Orders
  • Purge Invalid Users
  • Purge Invalid User Roles
  • Purge Inventory Adjustments
  • Purge Item
  • Purge Item Baskets
  • Purge Item Hierarchy
  • Purge Item Price
  • Purge Lockings
  • Purge Notifications
  • Purge Price Change Worksheet
  • Purge Price Histories
  • Purge Related Items
  • Purge Resolved UIN Problems
  • Purge RFID
  • Purge Sales Posting
  • Purge Shelf Adjustments
  • Purge Shelf Replenishment
  • Purge Staged Message
  • Purge Stock Counts
  • Purge Temporary UINs
  • Purge Ticket Histories
  • Purge Vendor Returns
• Data Purging Batches - BDI Staging Data
  • Purge BDI Inbound Price
  • Purge BDI Item
  • Purge BDI Item Loc
  • Purge BDI Location
  • Purge BDI Misc Group
  • Purge BDI Price Hist
  • Purge BDI Rfid
  • Purge BDI Store Inventory Avail
  • Purge BDI Supp Item
  • Purge BDI UDA
  • Purge BDI Warehouse Item Avail
• Batch Job Administration
  • Job Administration
    • Job Admin Screen
    • Job Execution Log Screen
    • Job Launch Screen
  • Job Scheduler
    • Job Scheduler Screen

6 Batch - Data Archive

• Archive Data Batches
• Archive Dump Batches
• Archive Batch Scheduling Consideration
• Archive Data Dump Files Export

7 Technical Maintenance Screens

• Barcode Processor
  • Barcode Processors
• Credential Administration
• External Printer Setup
• MPS Staged Message
• MPS Work Type
• POS Transaction Resolution
• Sequence Administration

8 Integration

• Overall Integration Touchpoints
• Retail Integration Cloud Service (RICS) - based Integration
  • Customer Orders
  • Picking
  • Deliveries
  • Reverse Picking
  • Multi Leg
  • RIB Payloads
  • Purchase Orders and Vendor Deliveries
  • Inventory Adjustments
  • Items
  • Stock Counts
  • Transfers
  • Transfer Creation
  • Transfer Messages
  • Transfer Shipment Creation
  • Transfer Receiving
  • Transfer Doc
  • Transfer Shipment
  • Transfer Receiving
  • Vendor Return
    • RTV Creation
    • RTV Shipment
• Batch Integration
  • Overview
  • BDI-Based Batch Integration
    • Initial Foundation Data Seeding
    • Recurring BDI Transaction Batches
    • BDI Transmitter CLI - Client Batch File Loader
  • SFTP-Based Batch File Integration
• Web Services
  • Security Considerations
  • Functionality
  • Available Web Services
  • Web Services Basic Design Principles
  • Internally Managed vs Externally Managed
  • Web Service Operation Basic Design Standards
  • Interpreting Validation Errors
    • Common Error Codes
    • Validation Error (Fault Example)
    • Business Error (Fault Example)
  • Web Services
    • ActivityLock
    • FulfillmentOrderDelivery
    • FulfillmentOrderPick
    • FulfillmentOrderReversePick
    • InventoryAdjustment
    • ItemBasket
    • OrderRequest
    • POSTransaction
    • ProductGroup
    • ProductGroupSchedule
    • ReplenishmentGap
    • RfidInventory
    • ShelfAdjustment
    • ShelfReplenishment
    • StockCount
    • Store
    • StoreFulfillmentOrder
    • StoreInventory
    • StoreInventoryISN
    • StoreInventoryUIN
    • StoreItem
    • StoreItemPrice
    • StoreNotification
    • StoreShipmentManifest
    • StoreShipmentReason
    • StoreTicket
    • StoreTransfer
    • TransferDelivery
    • TransferShipment
    • VendorDelivery
    • VendorReturn
    • VendorShipment
  • Enterprise Documentation
• Sales Integration
  • POS and Sales Audit Process Flow
    • Sales and Return Processing
    • Customer Order Processing
    • Item Disposition
    • Drop Ship
    • Item Types
    • RFID
• Integration with Manifesting Systems
  • Customer Order
• Integration for Ticket Printing
• Integration for Sales Forecast
• Integration for Store Order
• Retail Home Integration
  • Launch SIOCS from Retail Home
  • Tile Reports
  • EICS Endpoints
    • Shop Floor Out of Stock Items
    • Stock Counts - Ready to Authorize
  • SIOCS Operational Views
    • Launch SIOCS Operational Views from Tile Report

9 Configuration

• System Admin Parameters
• Store Admin Parameters
• Permissions

10 Operational Issues Screens

• Operational Issues List Screen
• Operational Issues Review
  • Operational Review Screen Actions
• Bulk Data Import
• Data Purge
• Message Processing
• Transactional Execution

A Appendix: Run Importer Separately from SIOCS Job Admin

• Run Data Seeding Importer Jobs
• BDI Transaction (TX) Importer Jobs

B Appendix: BDI Transmitter CLI Procedure - Load External Data File

• BDI Transmitter CLI Tool Setup
• Tool Usage
• File Processing
  • Output Logs
  • Error Reprocessing
• Schedule EICS Importer Jobs for Transmitter Loaded Data
• View EICS Importer Jobs Execution Details

C Appendix: BDI Security Roles and Groups

• BDI Batch Admin Security
• BDI Process Flow Security
• BDI Scheduler Security

D Appendix: Report Formats

• Reports
• Report Formats

E Appendix: Batch File Layout Specifications

• Third Party Stock Count Parser Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • Third Party Stock Count Import File Format
  • File Layout
• Clearance Price Change Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • File Record Types
  • File Layout
• Regular Price Change Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • File Record Types
  • File Layout
• Promotion Price Change Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • File Record Types
  • File Layout
• POS Sale Transaction Import File Specification
  • Filename Format
  • Zip Filename Format
  • POS Sale Transaction Import File Format
  • File Layout
• Retail Sale Audit Import File Specification
  • Filename Format
  • Zip Filename Format
  • ReSA Transaction Import File Format
  • File Layout
• Stock Count Results Export File Specification
• Store Sequence Data Parser Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • Store Sequence Import File Format
  • File Layout
• Warehouse Stock Import File Layout Specification
  • Filename Format
  • Zip Filename Format
  • Warehouse Stock Import File Format
  • File Layout
• Initial Inventory Import File Layout Specification
  • Filename Format
  • Initial Inventory Import File Format
  • File Layout
• Inventory Extract Export File Specification
  • Filename Format
  • Inventory Extract File Format
  • File Layout

F Appendix: Auto-Authorized Third-Party Stock Count Process Overview

• Third Party Processing
• Third Party Recovery

G Appendix: Unit and Amount Stock Counts Export

• Export File Layout
• Export File Location
• Export File Name

H Appendix: UPC Barcode

• Differences between UPC-A and UPC-E
• Conversion between UPC-A and UPC-E

I Appendix: EICS Provided URLs

• EICS web-client URL
• SOCS (connections config) URL
• EICS Web Service URLs
• BDI Related URLs
• EICS-RICS Integration URLs
  • EICS-RICS Message Publishing
  • Setting Up RIB Message Injector
• BI Related URL
• ORDS (Apex Data Viewer) URL

J Appendix: Data Seeding Process Flows

• Data Seeding Process Flows from Merchandising to EICS
• Data Seeding Mapping Tables between SIOCS and BDI

K Appendix: Pricing Import with On-premise RPM

• Clearance Price Change Import with On-premise RPM
• Promotion Price Change Import with On-premise RPM
• Regular Price Change Import with On-premise RPM

L Appendix: Open Transaction Seeding via BDI

• Overview
• BDI Implementation Considerations
  • Option A: BDI External Process Flow (via External Edge App)
  • Option B: BDI CLI Transmitter
• Open Transaction Data Processing
  • Direct Delivery - Import Details
  • Transfer - Import Details
  • Purchase Order - Import Details
  • Data Mapping
  • Data Import Exception Handling
• Additional Details for BDI CLI File Imports
  • DSD Interface Specification
  • Purchase Order Interface Specification
  • Transfer Interface Specification
• Setup BDI CLI File Transmitter Tool
• Run BDI CLI File Transmitter
• Run Importer Job

M Appendix: Third Party Pricing Integration

• Overview
• BDI Implementation Considerations
• Third Party Pricing Import via BDI CLI File Transmitter
• External Price File Layout
• File Contents Explanation

N Appendix: Third-Party RFID Integration

• Overview
• BDI Implementation Considerations
• Third-Party RFID Import via BDI CLI File Transmitter
• EXT_RFID_IN
• External RFID CSV File Fields
• File Contents Explanation

O Appendix: Item Ticket

P Appendix: SFTP File Directory and Filename Format

• File Upload Directory and Filename Format
• File Download Directory and Filename Format