Go to primary content
Oracle® Retail POS Suite 14.1/Merchandising 14.1 Implementation Guide
Release 14.1
E59307-03
Index
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 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