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 Direct Services
  • Using OCDS
  • Using Flat Files
  • Xstore Office Deployments
    • Using RMFCS/RPCS direct services or OCDS
  • Using Flat Files
  • Xstore Dataloader
  • Using RMFCS/RPCS direct services or OCDS
    • Using Flat Files
    • File Sorting
• Phased Rollout of Stores
  • Using RMFCS/RPCS direct services or OCDS (Cloud Only)
  • Using Flat Files
• Manual Refresh of an Xstore Database
  • Using RMFCS/RPCS direct services 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