Skip Headers
Oracle® Retail Price Management Operations Guide
Release 13.2.9
E71051-01
Next
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documentation
Documentation Accessibility
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
Configuration Files
rpm.jnlp
Data Source Configuration in Container
rib_user.properties
security.properties
Wallet Settings
For LDAP Authentication
For User Search
For Audit Logging
Single Sign-On with Oracle Technology
LoginModule Configuraton Information
For Mapping LDAP to Directory Schema
User Signature Information
User Authentication Information
dao_rpm.xml
users_rsm.xml
Configuration for Oracle Retail Service Layer (RSL) with services_rpm.xml
Logging
Jakarta Commons Logging
Log4j.xml
Logging Levels
Output Files
Hibernate Logging
Transaction Timeout and Client Inactivity Timeout
RPMTaskMDB
EJBs Used by RPMTaskMDB
Tables Used by RPMTaskMDB
RPMChunkMDB
Tables Used by RPMChunkMDB
Multi-threading of MDB
Configuring RPM without the RIB
No RIB Publishing
Configurable RIB Batch Program Notes
RMS—RPM Integration
Disabling RIB Publishing in RPM
Configuring RPM with RIB
RMS--RPM Integration
Internationalization
Translation
Set the Client Operating System to the Applicable Locale
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
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:�
Processed 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 Oracle Retail Allocation
From RPM to RMS
From RMS to RPM
From RPM to SIM and from SIM to RPM
From RPM to the RIB and from the RIB to RPM
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 Service Layer (RSL)
Functional Description of the Class Using RSL
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 Process�es
Java Based Batch Processes
PL/SQL Based Batch Processes
Additional Notes�
Script Catalog
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�
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
GenerateFutureRetailRollUpBatch 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 Simple 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�
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 �
Assumptions and Scheduling Notes�
Primary (RPM) Tables Involved�
Threading�
PL/SQL Interface Point�
NewItemLocBatch Batch Design�
Usage�
Detail �
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�
Bulk Conflict Checking�
Processing Stage Rows in Error Status�
PriceChangeAreaDifferentialBatch Batch Design�
Usage �
Additional Notes �
Details �
Assumptions and Scheduling Notes �
Primary Tables Involved �
PriceChangeAutoApproveResultsPurgeBatch Batch Design�
Usage�
Detail �
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�
PriceEventPayloadPopulationBatch Batch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
Threading
PriceStrategyCalendarBatch Batch Design�
Usage�
Detail �
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�
primaryZoneModificationsBatch Design
Usage
Details
Assumptions and Scheduling Notes
Primary Tables Involved
Threading
ProcessPendingChunkBatch Batch Design
Usage�
Detail �
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�
PromotionArchiveBatch Batch Design�
Usage�
Detail �
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�
PromotionPriceChangePublishBatch batch design�
Usage�
Detail �
Input Tables�
Output File Record Types�
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�
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�
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 File�s
Output File Layout
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�
Configuration�
RPMtoORPOSPublishBatch Batch Design
Usage
Detail
Output
Assumptions and Scheduling Notes
Primary Tables Involved
Configuration
RPMtoORPOSPublishExport Batch Design
Usage
Detail
OutputFile
Assumptions and Scheduling Notes
Primary Tables Involved
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�
Detail �
Assumptions and Scheduling Notes�
Primary Tables Involved�
Threading�