Contents

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 Technology Network
• Conventions

1 Integration Overview

• Data Import from Oracle Retail Merchandising System and Oracle Retail Price Management
  • Generic Data Import Flow
  • Feed Methods
  • Data Import Dependencies
• Oracle Retail Price Management to Oracle Retail POS Suite Integration Overview
• Oracle Retail Merchandising System to Oracle Retail POS Suite Integration Overview
• Oracle Retail POS Suite to Oracle Retail Sales Audit Overview
  • Oracle Retail POS Suite
  • Oracle Retail POS Suite RTLog Files
  • Transport Middleware
  • Oracle Retail Sales Audit
  • Preconditions
  • Changing RTLog Locations
  • System Flow Description
• Cross Version Support for DIMP

2 Integration Architecture

• Oracle Retail POS Suite to Oracle Retail Sales Audit Integration Architecture
  • RTLog Batch Generator
    • Sleep Interval
    • Maximum Transactions
    • Oracle Retail Sales Audit
• Data Import
  • Error Handling
  • Import Status Logging
    • The Logic
    • Reprocessing a Bundle
  • Exception Flow
  • Logging
  • Bundles Using Multiple Threads
• RTLog Mapping and Translation

3 Implementation Configuration

• Data Import Spring Configurations
  • spring.properties
  • dimplogger.properties
• Archive File Format
• Oracle Retail Merchandising System Configuration
• Oracle Retail Price Management Configuration

4 Capacity Planning

5 Customization Notes

• Data Import Extension Points and Development
  • Import Adapter and Translator
    • SAXParserGenerator
    • Manually Editing Generated Code
  • Metadata
  • ImportControllerIfc
• Oracle Retail POS Suite to Oracle Retail Sales Audit Extension Points and Development
  • Adding Data Elements to the RTLog Format
  • Blocking Transaction Export
  • Creating a New Fixed Length Export Record Format
  • Exporting a Non-Fixed-Length Record Format
  • Object Factories
    • StoreServerConduit.xml
    • DomainObjectFactory
    • ExtractorObjectFactory
    • EntityMappingObjectFactory
    • RTLogMappingConfig.xml
    • RecordFormatObjectFactory
  • Configuration
    • The Store Server Conduit File
    • The Export Format Configuration File
    • The Entity Reader Configuration File
    • The Mapping Configuration File
  • Development and Testing Tools
    • Classes
    • Executables in the bin Directory

6 Known Issues and Troubleshooting

• Authorized for Sale
• Currency.XML Import Restart
• Data Import
• Data Import Field Width Maximums
• Download of Items Currently on Promotion to New Stores
• Hardcoded Attributes in Oracle Retail Merchandising System Extracts
• Item Cost Attribute
• Jar Extract
• Multiple Regular Price
• Need To Escape Special Characters In XML File
• Preload Section of ItemImport
• Price Promotion/Discount Rule endDateTime in Pricing Import XSD
• Promotion ID Item Not On File
• Reason Codes for Price Discount
• RegistryEligible Field
• Retail Price Field Size Limitation
• Special Order Eligible Coupons
• Store ID Maximum Length
• Transaction-Level Items
• Single VAT Code Per Item

7 Existing Functionality Gaps

• Oracle Retail Price Management
• Oracle Retail Point-of-Service
• Oracle Retail Merchandising System
• Data Import Field Width Maximums
• Known Integration Gaps
  • Bank Deposit Details
  • Branded Debit Card Transactions
  • CatchWeight Item in RTLog
  • Character Restrictions for UOMs
  • CTILL Records in the RTLog
  • Data Mismatches in Data Import
    • Character Restrictions for ContactAddressCity
    • Character Restrictions for External Event ID
    • Character Restrictions for Item Cost/Unit Cost
    • Character Restrictions for PriceOverrideAmount
    • Character Restrictions for Pricing Coupon
    • Character Restrictions for Pricing Discount Percent, Discount Amount and New Price
    • Character Restrictions for PricingGroupID
    • Character Restrictions for Pricing Promo Description and Promo Name
    • Character Restrictions for UPC
    • Data Information for UOM
    • Geocode Data Missing
  • DepartmentDefaultTaxGroup
  • Discountable Attribute from Oracle Retail Merchandising System
  • Empty Item Classes Lists for Data Import
  • Geocode Tag Missing For Store
  • Gift Card Error
  • IGTAX Records in RTLog
  • Item Export: VATCode Datatype Mismatch
  • Layaway Deletion Fee
  • Missing Encryption Key For Saencrypt.pc
  • NM ITEM Codes in Oracle Retail Sales Audit
  • POSDepartmentID
  • Postal Code
  • Predefined Store ID
  • Price Changes and Price Promotions
  • Pricing Extract: Start Date and End Date Mismatch
  • Pricing Extract: Store ID Datatype Mismatch
  • Pricing Group ID: Data Mismatch
  • Reason Codes for Discount Rules
  • Third-party Tax and Employee Information
  • Till Opening and Closing
  • Total ID in the RTLog
  • UTF-8

A Appendix: Discount Rules – Any or All

B Appendix: Pricing Rules

• Multi-Buy
  • Oracle Retail Price Management Multi-Buy Assumptions
• Threshold
  • Threshold Assumptions
• Simple
• Kits
• Finance Promotion
• Transaction Promotion
  • Oracle Retail Price Management Transaction Assumptions

C Appendix: XSD Files and Data Element Definition Tables

• Currency Import
• Customer Import
• Employee Import
• Item Import
• Merchandise Hierarchy Import
• Pricing Import
• Returns Customer Import
• ScanSheet Import
• Store Hierarchy Import
• Tax Import

D Appendix: Default Tax Handling

• The Default Tax Rate
• The Default Tax Type Indicator (VAT)

E Appendix: Item Price Category

Glossary

Index