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

2 Data Flow from Merchandising to Xstore using Omnichannel Data Service (OCDS)

• Conceptual Data Flow
• Xstore Office Deployments
• Phased Rollout of Stores [CLOUD ONLY]
• Manual Refresh of an Xstore Database from OCDS

3 Transaction Flow from Xstore to Sales Audit

• Conceptual Data Flow
• Technical Implementation
  • Xstore Broadcaster
  • Xstore RTLog Generator
  • Sales Audit saimptlog/i

4 OCDS Integration Configuration

• Xstore Office: OCDS Integration Communication
• Xstore Office: Omnichannel Data Service Configuration Options
• Merchandising Chain to Xstore Organization Mapping
• OCDS Database Tables
• Seed Data for VAT and Non-VAT Organizations
• Download: Immediate vs Store Close

5 Integration Considerations

• Foundation Data
  • Seed Data
  • Transaction Details
  • 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
• Retrieving Published RTLog Files
• Security Configuration
• Acquiring IDCS or OCI IAM Token
• Provide IDCS or OCI IAM 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