Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Customer Support
• Documentation Accessibility
• Supplemental Documentation on My Oracle Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

2 Backend System Administration and Configuration

• Supported Environments
• Exception Handling
• Logging
  • Jakarta Commons Logging
  • Log4j.xml
  • Logging Levels
  • Hibernate Logging
• Transaction Timeout and Client Inactivity Timeout
• RPMTaskMDB
  • EJBs Used by RPMTaskMDB
  • Tables Used by RPMTaskMDB
• PRMChunkControllerMDB and RPMChunkMDB
  • Tables Used by RPMChunkMDB
• Multi-Threading of MDB
• Configuring RPM without the RIB
• Disabling RIB Publishing in RPM
• Configuring RPM with RIB
• RMS--RPM Integration
• Internationalization
  • Translation
  • Set the Client Operating System to the Applicable Locale
    • Setting the RPM UI Language through the URL
  • Resources_xx.properties
  • Adjusting the Default Font from Settings to Ensure Proper Display of Asian Characters
    • Adjust the Default Font Settings
• Price Management Status Page
  • Command Usage
    • Sample Output
• Custom Attributes
  • Custom Validation of Custom Attributes

3 Technical Architecture

• Overview of RPM Architecture
• The Layered Model
  • Client
  • Application Services Layer (Stateless Session Beans)
  • Core Services Layer
  • Persistence Layer
  • Database Layer
  • Security
    • User Repository (Such As a Third-Party Directory Server)
• Asynchronous Processing
  • Asynchronous Processing Flow
• RPM Cached Objects
• RPM-related Java Terms and Standards
• Conflict Checking

4 Conflict Checking

• Merge Validator Conflict Checking Rules
• Post-Merge Conflict Checking Rules (rpm_conflict_query_control Table)
• Rules Controlled by System Options
• Adding User-Defined Conflict Checking Rules
• RPM_FUTURE_RETAIL
• Bulk Conflict Checking
  • Overview of Bulk Conflict Checking and Its Impact on Performance
    • Processed First: Sequence One
    • Process Second: Sequence Two
  • Chunk Conflict Checking
• Skipping Conflict Checking during Submit
• Skipping Conflict Checking during Complex Promotion Approval
• Conflict Checking Refresh

5 Integration Methods and Communication Flow

• Functional Dataflow
  • A Note about the Merchandising System Interface
• Integration Interface Dataflow Diagram
• Integration Interface Dataflow Description
  • From Oracle Retail Allocation to RPM
  • From RPM to RMS
  • From RMS to RPM
  • From RPM via Generic Flat File Interface
  • From SIM to RPM
  • From RPM to the RIB
  • From RPM to ORPOS
• Pricing Communication Flow Diagram
  • Approved Price Events
  • Price Events
  • Price Inquiry
  • Promotion Detail
• RPM and the Oracle Retail Integration Bus (RIB)
  • The XML Message Format
  • Message Publication Processing
  • Publishers Mapping Table
  • Functional Descriptions of Publication Messages
• RPM and the Oracle Retail Web Service Layer
  • Functional Description of the Class Using Web Service Layer
• Persistence Layer Integration
  • RMS Tables Accessed through the Persistence Layer
  • RMS Packages and Methods Accessed through RPM's Persistence Layer
  • RPM Views Based on RMS Tables
  • RPM Packages Called by RMS
• Oracle Retail POS Suite - RPM Integration
  • Overview
    • Oracle Retail POS Suite
    • Integration
    • File Details
  • Integration Dataflow
  • Functional Description of Dataflow
    • From RPM to ORBO
    • Data Bundling
  • Known Issues From the Oracle Retail Price Management Perspective
    • Mismatch in Promotion Functionality
    • Assumptions
    • Other Gaps Between RPM and Oracle Retail POS Suite
  • Known Issues From the Oracle Retail POS Suite Perspective

6 Functional Design

• Functional Assumptions
• Functional Overviews
  • Zone Structures
  • Codes
    • Market Basket Codes
    • Link Codes
  • Pricing Strategies
    • Area Differentials
    • Clearance Strategy
    • Clearance Default Strategy
    • Competitive Strategy
    • Margin Strategy
    • Maintain Margin Strategy and Auto Approve
    • Merch Extract Calculations
  • Price Inquiry
  • Worksheet
    • Merchandise Extract
  • Calendar
  • Aggregation Level
  • Location Moves
• Application Security
  • Oracle Retail Security Manager Overview
  • Named Permissions
  • Actions and Named Permissions
  • Content Models and Named Permissions
  • Hierarchy (Data Level) Permissions
  • Roles and Users
• Concurrency Considerations
  • Pessimistic Data Locking
  • Pessimistic Workflow Locking
  • Last User Wins
  • Optimistic Data Locking
  • Concurrency Solution/Functional Area Matrix

7 Java Batch Processes

• Java Batch Processes
  • Java Batch Process Architectural Overview
  • Running RPM Batch Processes
    • Java Based Batch Processes
    • PL/SQL Based Batch Processes
    • Additional Notes
  • Scheduler and the Command Line
  • Functional Descriptions and Dependencies
  • Batch Process Scheduling
  • Threading and the RPM_BATCH_CONTROL Table
  • Return Value Batch Standards
  • Return Values
  • Batch Logging
  • Batch Run History Logging
  • ClearancePriceChangePublishBatch Batch Design
    • Usage
    • Detail
    • Output File
    • Output File Layout
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
    • Configuration
  • FutureRetailRollUpBatch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • InjectorPriceEventBatch Batch Design
    • Usage
    • Additional Notes
    • Details
    • Importing Staged Price Changes
    • Importing Staged Clearances
    • Importing Staged New Clearance Reset Data
    • Importing Staged Simple Promotions
    • Importing Staged Threshold Promotions
    • Importing Staged Multi-Buy/Complex Promotions
    • Importing Staged Finance Promotions
    • Importing Staged Transaction Promotions
    • Main Steps Taken by the Batch
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • InjectorPriceEventBatch Batch—Rollback and Reprocessing
  • ItemLocDeleteBatch Batch
    • Usage
    • Scheduling Notes
  • itemReclassBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
    • PL/SQL Interface Point
  • LocationMoveBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • LocationMoveScheduleBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary (RPM) Tables Involved
    • Threading
  • MerchExtractKickOffBatch Batch Design
    • Usage
    • Detail
  • NewItemLocBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
    • Bulk Conflict Checking
    • Processing Stage Rows in Error Status
    • Processing Stage Rows in Restart Status
  • NightlyBatchCleanup Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Threading
  • PriceChangeAreaDifferentialBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
  • PriceChangeAutoApproveResultsPurgeBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PriceChangePurgeBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PriceChangePurgeWorkspaceBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • Price Event Execution Batch Processes
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • RMS Interface Point
    • Threading
  • PriceEventExecutionForChunkCCEmergencyEvents Batch Design
    • Usage
    • Detail
    • Primary Tables Involved
    • Threading
  • PriceEventItemListPurgeBatch Batch Design
    • Usage
    • Detail
    • Primary Tables Involved
    • Threading
  • PriceStrategyCalendarBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • primaryZoneModificationsBatch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • ProcessPendingChunkBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PromotionArchiveBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PromotionPriceChangePublishBatch Batch Design
    • Usage
    • Details
    • Input Tables
    • Output File Layout
    • Assumptions and Scheduling Notes
    • Threading
    • Configuration
  • PromotionPurgeBatch batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PurgeBulkConflictCheckArtifacts Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
  • PurgeConCheckResultsErrorData Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PurgeExpiredExecutedOrApprovedClearancesBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PurgeLocationMovesBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • purgeRPMBatchRunHistory Batch Design
    • Usage
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
  • PurgePayloadsBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • PurgeUnusedAndAbandonedClearancesBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • RefreshPosDataBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Output
    • Threading
  • RegularPriceChangePublishBatch Batch Design
    • Usage
    • Detail
    • Output Files
    • Output File Layout
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
    • Configuration
  • RPMtoORPOSPublishBatch Batch Design
    • Usage
    • Details
    • Output
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Configuration
  • RPMtoORPOSPublishExport Batch Design
    • Usage
    • Detail
    • Output File
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
    • Configuration
  • stagePromosForExtDashboard Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • statusPageCommandLineApplication Batch Design
  • TaskPurgeBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • WorksheetAutoApproveBatch Batch Design
    • Usage
    • Detail
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
  • ZoneFutureRetailPurgeBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading