Go to primary content
Oracle® Retail Xstore Suite 21.0/Oracle® Retail Merchandising Suite 21.0.000 Implementation Guide
Release 21.0
F49453-02
Next
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documents
Customer Support
Review Patch Documentation
Improved Process for Oracle Retail Documentation Corrections
Oracle Retail Documentation on the Oracle Help Center (docs.oracle.com)
Conventions
1
Overview
Inbound: Integration Options with Xstore Office
Outbound: Integration Options with Xstore Office
2
Data Flow from Merchandising to Xstore
Conceptual Data Flow
Using RMFCS/RPCS
Using OCDS
Using Flat Files
Xstore Office Deployments
Using RMFCS/RPCS or OCDS
Using Flat Files
Xstore Dataloader
Using RMFCS/RPCS or OCDS
Using Flat Files
File Sorting
Phased Rollout of Stores
Using RMFCS/RPCS or OCDS (Cloud Only)
Using Flat Files
Manual Refresh of an Xstore Database
Using RMFCS/RPCS or OCDS
Using Flat Files
3
Transaction Flow from Xstore to Sales Audit
Conceptual Data Flow
Technical Implementation - Sales Audit REST Integration
Sales Audit REST Xstore Broadcaster
Sales Audit REST Endpoints
Scheduled Job to Query Sales Audit Rejected Transactions
Xadmin UI to View and Republish Sales Audit Rejected Transactions
Technical Implementation - RTLog Files Integration
RTLog File Xstore Broadcaster
Xstore RTLog Generator
Sales Audit saimptlog/i
4
Webservice Integration Configuration
Xstore Office: Direct Service Integration Communication
Merchandising Configuration
POM Configuration
Xstore Office: OCDS Integration Communication
Xstore Office: Omnichannel Data Service Configuration Options
Merchandising Chain to Xstore Organization Mapping
Integration Database Tables
Enabling and Disabling Data Types
Download: Immediate vs Store Close
"NOT ON FILE" Items
5
Integration Considerations
Foundation Data
Seed Data
Transaction Details
Multi-Line Text
Currency Exchange Rates
Stores
Merchandise Hierarchy
Items
Merchandise Items
Non-Merchandise Items
Kit/Pack Items
Differentiators
Product Restrictions
Related Items
Other Item Attribute Notes
Tax
Value Added Tax (VAT)
US Sales Tax
Inventory
Serialized Inventory
Customer Orders
In-Store Orders
Recognition of a Sale
Pricing
Multi-Unit Pricing
Promotions
Sales Audit
Store Data Configuration
Register-level Balancing
Sales Person
Tender Types
Coupons
File Format
Employee IDs
6
RTLog Generator On-Premise
Configuration
Deployment
WebLogic Cluster Setup
Deployment of the RTLog Generator Application on a Cluster
Security Configuration
Container Level Security
Transport Level Security
Complete the Security Configuration
7
RTLog Generator Cloud
RTLog Generator Cloud
Configuration
Integration
Updating Mapping Configuration
Updating Format Configuration
Retrieving Published RTLog Files
Security Configuration
Acquiring IDCS Token
Provide IDCS Authentication
A
Appendix: Xstore to Sales Audit Mapping Details
Transaction Types
Tender Types
Tender Totals
Item Types
Sales Audit Reason Codes
Reason Codes
Return Reason Codes
Discount Reason Codes
Item Price Override Reason Codes
Item Status/and Sales Types
Customer ID Types
Sales Audit Tax Codes
Reference Codes/Labels
Sale Return Transaction
Transaction Header Mapping
Line Item (TITEM) Mapping
Item Discount (IDISC) Mapping and Round off Discount Mapping
Item Level Tax Mapping
Tender Line Mapping
Rounded Off Amount
B
Appendix: Flat File Mapping
RMS Diff Group Detail
RMS Diff Group Header
RMS Diffs
RMS Item Header
RMS Item Location
RMS Merchandise Hierarchy
RMS Organizational Hierarchy
RMS Related Item Detail
RMS Related Item Header
RMS Store
RMS Store Address
RMS VAT
RMS VAT Item
RPM Clearance Price
RPM Regular Price
RPM Promotions