Go to primary content
Oracle® Price Management Operations Guide
Release 15.0.3
F18741-01
Next
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Related Documents
Customer Support
Review Patch Documentation
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
FutureRetailPurgeBatch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
Threading
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
NewItemLocPublishMBPromoBatch Batch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
Threading
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