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
  • 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 EICS 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
  • 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 RFID History
  • Archive Store Item Stock History
  • Archive Item Uin History
  • Auto Replenish Capacity
  • Cleanup Batch Directories
  • Cleanup Shelf Replenishment
  • DSD Receiving Closure
  • 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 File SFTP Push
  • Stock Count Unit and Amount Snapshots
  • 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
  • High Level Batch File Process Overview
  • Clearance Price Change Import (with On-premise RPM)
  • 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
  • Store Sequence Import
  • Third Party Stock Count Import
  • Warehouse Item Stock Import
  • SFTP Nightly Batch File Uploads
    • Adding Authorized Keys
    • Login to WinSCP
    • Uploading a Batch File
    • Export File Downloads
• Purge Batches
  • Purge Adhoc Stock Count
  • Purge Areas
  • Purge Batch Log
  • Purge Closed Transfers
  • Purge Completed UIN Detail
  • Purge DSD and Purchase Orders
  • Purge Fulfillment 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 UIN Detail
  • 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 Admininistration
  • 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
• External Printer Setup
• MPS Staged Message
• MPS Work Type

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
  • 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
    • Web Service: ActivityLock
    • Web Service: FulfillmentOrderDelivery
    • Web Service: FulfillmentOrderPick
    • Web Service: FulfillmentOrderReversePick
    • Web Service: InventoryAdjustment
    • Web Service: Item Basket
    • Web Service: POSTransaction
    • Web Service: ProductGroup
    • Web Service: ProductGroupSchedule
    • Web Service: ReplenishmentGap
    • Web Service: RfidInventory
    • Web Service: ShelfAdjustment
    • Web Service: ShelfReplenishment
    • Web Service: StockCount
    • Web Service: Store
    • Web Service: StoreFulfillmentOrder
    • Web Service: StoreInventory
    • Web Service: StoreInventoryISN
    • Web Service: StoreInventoryUIN
    • Web Service: StoreItem
    • Web Service: StoreItemPrice
    • Web Service: StoreNotification
    • Web Service: StoreShipmentManifest
    • Web Service: StoreShipmentReason
    • Web Service: StoreTransfer
    • Web Service: TransferDelivery
    • Web Service: TransferShipment
    • Web Service: VendorDelivery
    • Web Service: VendorReturn
    • Web Service: 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 Address
• Integration for Ticket Printing
  • Ticket Print
• Retail Home Integration
  • Launch EICS from Retail Home
  • Tile Reports
  • Create Tile
  • Add Tile State
  • Add Data Source
  • EICS Endpoints
    • Shop Floor Out of Stock Items
    • Stock Counts - Ready to Authorize
  • EICS Operational Views
    • Launch EICS Operational Views from Tile Report

9 Configuration

• System Admin Parameters
• Store Admin Parameters
• Access Permissions
• Data 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 EICS 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: Report Formats

• Reports
• Report Formats

D 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
• Inventory Extract Export File Specification
  • Filename Format
  • Inventory Extract File Format
  • File Layout

E Appendix: Setup Auto-Authorized Third-Party Stock Count

F Appendix: Unit and Amount Stock Counts Export

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

G Appendix: UPC Barcode

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

H 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

I Appendix: Data Seeding Process Flows

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

J 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

K Appendix: Open Transaction Seed

• Overview
  • Direct Delivery - Transaction Import
  • Transfer - Transaction Import
  • Purchase Order - Transaction Import
• Technical Design
• Technical Architecture
• Data Process Flow
• Exception Handling
• Data Mapping

L Appendix: Third Party Pricing Integration

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