Skip Headers
Oracle® Price Management Operations Guide
Release 16.0
E80051-01
Next
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
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
Configurable GTT Capture
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
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
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
Logger
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
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
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
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
PurgeBatch Batch Design
Usage
Detail
Primary Tables Involved
PurgeGttCaptureBatch Batch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
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
stagePromosForExtDashboard Batch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
Threading
statusPageCommandLineApplication Batch Design
WorksheetAutoApproveBatch Batch Design
Usage
Detail
Assumptions and Scheduling Notes
Primary Tables Involved
Threading