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 on the Oracle Technology Network
• 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?
  • Business Objects for Data Seeding
• Why Use Data Seeding?
• When To Run Data Seeding
• How BDI Data Seeding Functions
• EICS Data Seeding Preparation
  • EICS Data Seeding Security Settings
  • EICS Data Seeding Configuration Parameters
  • Managing Data Seeding Process Configurations
• BDI-Based Data Seeding
  • BDI-Based Data Seeding Pre-requisites
  • Start BDI-Based Data Seeding Process
  • BDI Process Flow Admin Console
    • Extractor
    • Downloader
    • Uploader/Receiver
    • Importer
    • Load 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

• Client Translations
• Server Translations
• Translation Topics
• Translation Keys
• Server Operations
  • Lookup Translation Records
  • Add/Update Translation Records
  • Delete Translation Records
• JET Screens
  • Translation Setup
• Report Translations

5 Batches

• Operation Batches
  • Archive Activity History
  • Archive Store Item Stock History
  • Archive Item Uin History
  • 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
  • Item Price to History
  • Product Group Schedule Cleanup
  • Return Not After Date Alert
  • Stock Count Authorize Recovery
  • 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
  • Wastage Inventory Adjustments
• 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
  • File-Based Batch List
    • Clearance Price Change Import
    • Inventory Extract
    • Pos Transaction Import
    • Promotion Price Change Import
    • Regular Price Change Import
    • Retail Sale Audit Import
    • Store Sequence Import
    • Third Party Stock Count Import
    • Warehouse Item Stock Import
  • Nightly Batch File Uploads
    • Adding Authorized Keys
    • Login to WinSCP
    • Uploading a Batch File
    • Export File Downloads
• Purge Batches
  • Purge Adhoc Stock Count
  • 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 Price
  • Purge Item Hierarchy
  • 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 Replenishment
  • Purge Staged Message
  • Purge Stock Counts
  • Purge Temporary UIN Detail
  • 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 Admin Overview
  • Batch Users
  • Configuration
  • Administration
    • Job Admin Screen
    • Job Execution Log Screen
    • Job Launch Screen
  • Job Scheduler
    • Job Scheduler Screen

6 Batch - Data Archive

• Archive Batch Summary
• Audits_ArchiveJob (Archive Activity Job)
  • Key Tables
  • Scheduling Consideration
• ItemUinHistory_ArchiveJob (Archive Item UIN History Job)
  • Key Tables
  • Scheduling Consideration
• StoreItemStockHistory_ArchiveJob (Archive Store Item Stock History Job)
  • Key Tables
  • Scheduling Consideration
• ArchiveDump_OpsJob (Archive Dump Job)
  • Key Tables
  • Scheduling Consideration

7 Technical Administration Screens

• Barcode Processor
  • Barcode Processors
• External Printer Setup
• MPS Staged Message
• MPS Work Type

8 Integration

• Retail Integration Cloud Service (RICS) - RIB 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
  • Business Objects
  • Transfer Doc
  • Transfer Shipment
  • Transfer Receiving
  • Vendor Return
  • RTV Creation
  • RTV Shipment
• Batch Integration
  • 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: ShipmentReason
    • Web Service: StockCount
    • Web Service: Store
    • Web Service: StoreFulfillmentOrder
    • Web Service: StoreInventory
    • Web Service: StoreInventoryUIN
    • Web Service: StoreItem
    • Web Service: StoreItemPrice
    • Web Service: StoreNotification
    • Web Service: StoreTransfer
    • Web Service: TransferDelivery
    • Web Service: TransferShipment
    • Web Service: VendorDelivery
    • Web Service: VendorReturn
    • Web Service: VendorShipment
• Enterprise Documentation
• Sales Processing
  • POS and Sales Audit Process Flow
    • Sales and Return Processing
    • Customer Order Processing
    • Item Disposition
    • Wastage
    • Drop Ship
    • Item Types
    • RFID
• Manifesting
• Customer Address

9 System Admin Parameters

10 Store Admin Parameters

A Appendix: Run Importer Separately from EICS Job Admin

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

B Appendix: EICS Data Loading Performance Consideration

• Disabling Constraints
• Enabling Constraints (Critical Process)

C 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

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

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

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: Permissions

• Security Permissions
• Data Permissions