Go to primary content
Oracle® Retail Enterprise Inventory Cloud Service Administration Guide
Release 19.7
F70119-01
Next
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