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
• Cloud Deployment
  • EICS Client
  • SOCS Mobile Client
  • Web Services
  • WTSS / IDCS or OCI IAM
  • EICS Application Server(s)
  • Oracle DB Server (DBaaS)
  • Client-Server Communication
• Integration
  • Oracle Retail Integration Bus (RIB)
  • SOAP Web Services
• Deployment
• Deployment - Performance: Bandwidth, Scaling
  • Bandwidth Requirements for Browser Clients
  • Network Latency Constraints
  • Application Server Clustering
  • Database Clustering with RAC

2 Data Seeding

• Data Seeding from Merchandising Foundation Cloud Service
  • Overview
  • When to Run Data Seeding
  • Data Seeding Modules
  • Data Seeding Steps
    • Pre-requisites for Seeding from Co-Deployed MFCS
    • Assign Application Roles for Initial Data Loading
    • Assign Security Permissions for Initial Data Loading
    • Initial Data Loading System Configuration
    • Submit Seed
    • View Selected Module Executions
    • View Selected Module Execution Details
    • Re-run Initial Data Loading
    • Initial Data Loading Post Steps
  • Data Seeding MFCS-SIOCS View Mappings
• Standalone Data Seeding
  • Overview
  • System Admin Parameters
  • Initial Data Loading Process
  • Data Seeding Modules
  • File Layouts
    • Differentiator Type File
    • Item Hierarchy File
    • Partner File
    • Supplier File
    • Transfer Zone File
    • UDA File
    • UOM Class File
    • Warehouse Class File
    • Differentiator File
    • Item File
    • Partner Address File
    • Supplier Address File
    • Supplier CFA File
    • Supplier Organization File
    • UDA LOV File
    • UOM Conversion File
    • Warehouse Address File
    • Item CFA File
    • Item Component File
    • Item Description File
    • Item Image File
    • Item UDA File
    • Partner Item File
    • Related Item Type File
    • Supplier Item File
    • Warehouse Item File
    • Related Item File
    • Supplier Item Country File
    • Supplier Item Manufacture File
    • Supplier Item UOM File
    • Supplier Item Country Dimension File
    • Store File
    • Store Address File
    • Store Item File
    • Store Item CFA File
    • Store Item Stock File
    • Store Item Price File
    • Store Item Price History File
    • Store UIN Admin Item File
  • Supported Locales

3 Reporting

• 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

• Overview
• Batch Admin Users
• Batch Configuration
• Operational Batches
  • Auto Replenish Capacity
  • Auto Ticket Generate
  • Auto Ticket Print
  • Generate Problem Line Stock Count
  • Generate Unit Amount Stock Count
  • Generate Unit Stock Count
  • Initial Foundation Data File Import
  • Initial Inventory Import
  • Initial Store Data File Import
  • Item Basket Maintenance
  • Item Price ICL Import Batch
  • Retail Sale Audit Import Batch
  • Shelf Replenishment Closure
  • Stock Count Authorize Recovery
  • Stock Count Export
  • Stock Count Unit and Amount Snapshot
  • Store Order Auto Approve
  • Store Order Auto Cancel
  • Store Order Auto Generate
  • Third Party Price Import Batch
  • Third Party RFID File Import Batch
  • Third Party Stock Count Batch
• Cleanup Batches
• Batch Job Administration
  • Job Administration
    • Job Admin Screen
    • Job Execution Log Screen
    • Job Launch Screen
  • Job Scheduler
    • Job Scheduler Screen

6 Technical Maintenance Screens

• Credential Administration
  • Detail Panel
• External Service Administration
  • Detail Panel
• File Transfer Service
  • Detail Panel
• Job Admin
• Job Scheduler
• MPS Staged Message
• MPS Work Type
  • Detail Panel
• POS Transaction Resolution
  • Detail Screen
• Sequence Administration
  • Detail Panel

7 Integration

• 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
• 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 Customer Order System
• Integration with Manifesting Systems
• Integration for Notifications
• Integration for Sales Forecast
• Integration for Store Order
• Integration for Ticket Printing
• 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

8 Configuration

• System Admin Parameters
• Store Admin Parameters
• Permissions

9 Operational Issues Screens

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

10 File Transfer Services

• Overview
• How to Call FTS APIs
  • Service Base URL
  • Bucket Name
  • FTS Endpoints
  • Preparing for Authorization
  • Retrieving Access Client Token
  • FTS API Call Common Headers
  • How to Use FTS API to find Object Storage Prefixes
  • How to Use FTS APIs to Upload Files to Object Storage
    • Step1: Request upload PAR
    • Step2: Use PAR to upload data files to Object Storage
  • How to Use FTS API to List Files in Object Storage
  • How to Use FTS APIs to Download Files from Object Storage
    • Step1: Find what files are available for downloads
    • Step2: Request Download PAR for downloading data files from Object Storage
    • Step3: Download the file using the par returned from step2
• Handling Import Data Files
  • Supported Import Data Files
  • Steps to Transfers Import Data Files to Object Storage
• Handling Export Data Files
  • Supported Export Data Files
  • Steps to Download Export Data Files from Object Storage
• File Transfer Service UI
• FTS API Specifications
  • Ping
  • List Prefixes
  • List Files
  • Move Files
  • Delete Files
  • Request Upload PAR
  • Request Download PAR
• FTS Enabled Third Party File Import Batches
  • 1 Third Party RFID File Import Batch
    • Third Party RFID CSV File Fields
    • File Contents Explanation
  • 2 Third Party Price Import Batch
    • Third Party Price Import File Layout
    • File Contents Explanation
  • 3 Third Party Initial Inventory File Import Batch
    • Zip Filename Format
  • 4 Third Party Stock Count Import
    • Zip Filename Format
    • File Layout
• Test FTS API using Postman
  • Step 1: Get Client Access Token
  • Step 2: Call FTS Endpoints

A Appendix: Report Formats

• Reports
• Report Formats

B Appendix: Batch File Layout Specifications

• Retail Sale Audit Import File Specification
  • Filename Format
  • File Layout
• Stock Count Results Export File Specification

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

• Third Party Processing
• Third Party Recovery

D Appendix: Unit and Amount Stock Counts Export

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

E Appendix: UPC Barcode

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

F Appendix: EICS Provided URLs

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

G Appendix: Data Seeding Process Flows

• Data Seeding Process Flows from Merchandising to EICS