Go to primary content
Oracle® Retail Enterprise Inventory Cloud Service Administration Guide
Release 19.3
F44220-03
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 RFID History
Archive Store Item Stock History
Archive Item Uin History
Auto Replenish Capacity
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
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)
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
Initial Inventory 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 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
Web Service: ActivityLock
Web Service: FulfillmentOrderDelivery
Web Service: FulfillmentOrderPick
Web Service: FulfillmentOrderReversePick
Web Service: InventoryAdjustment
Web Service: ItemBasket
Web Service: OrderRequest
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: StoreTicket
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 Order
Integration for Ticket Printing
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
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 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
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: 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 Seed
Overview
Direct Delivery - Transaction Import
Transfer - Transaction Import
Purchase Order - Transaction Import
Technical Design
Technical Architecture
Data Process Flow
Exception Handling
Data Mapping
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