In Oracle Retail, a Promotion is a temporary event. It lowers the price of an item for a specific duration, after which the system automatically reverts the price to its original Regular Retail.

The Promotions Framework in Oracle Retail Price Management (RPM) and Pricing Cloud Service (PCS) is massive. It supports everything from a simple 10% off sale to complex, basket-level transaction triggers. This guide covers the promotional architecture and how these events flow down to the Point of Sale.

1. Types of Promotions#

RPM categorizes promotions into several distinct types, known as "Components".

Simple Promotions

A direct discount on a single item.

• 20% Off all Nike Shoes.
• Save $5 on Gallon Milk.
• Fixed Price: All T-Shirts $10.

Multi-Buy Promotions (BOGO)

Discounts triggered only when multiple qualifying items are purchased together.

• Buy One, Get One Free (BOGO).
• Buy 2, Get the 3rd at 50% Off.
• Buy 3 units for $12.

Threshold Promotions

Discounts triggered by the total value or volume of the customer's shopping basket.

• Spend $100 on Cosmetics, get 15% off the basket.
• Buy 5 items across the store, get $10 off.

2. The Promotional Hierarchy#

RPM organizes promotional data hierarchically to support marketing campaigns.

1. Promotion (The Campaign): The highest level. (e.g., "Back to School 2026"). It defines the start and end dates for the entire marketing event.
2. Component: The specific offers within the campaign. (e.g., "20% off Backpacks", "BOGO Notebooks").
3. Component Detail: The granular intersection of the Component rules and the actual Item/Zone combinations.

This hierarchy allows a pricing analyst to cancel the entire "Back to School" promotion with one click, automatically ending all 50 underlying component offers.

3. Promotion Execution and POS#

Unlike Regular Price Changes, which update ITEM_LOC.UNIT_RETAIL in the core merchandising system, Promotions do not permanently alter the item's baseline value.

The POS Payload

The primary consumer of Promotional data is not RMS—it is the Point of Sale (POS) system (e.g., Oracle Xstore). When a promotion is Approved in RPM, the system generates a massive payload detailing the rules (e.g., "Item 123 is 50% off if purchased with Item 456"). This payload is broadcast to the store registers.

When a customer checks out, the POS reads the barcodes, evaluates the active promotion rules stored in its local database, and applies the discount to the transaction receipt.

The RMS Impact

RMS only finds out about the promotion after the item is sold. When the POS sends the Sales Audit file (Tran Code 1) back to RMS at the end of the day, the sale is recorded at the discounted promotional price, impacting the gross margin for that day.

4. Core Tables Reference#

(Note: These are RPM schema tables)

Promotion Header (RPM_PROMO)

5. SQL Deep Dives#

Auditing Active Promotions

This query extracts all items that are actively on a Simple Promotion today, showing the promotional discount percentage relative to their regular retail price.

SELECT 
    rp.promo_name,
    rpc.comp_type, -- '0' (Simple), '1' (Threshold), '2' (Multi-buy)
    rpcd.item,
    rpcd.zone_id,
    rpcd.discount_type, -- '%' (Percent), 'A' (Amount Off), 'F' (Fixed Price)
    rpcd.discount_value,
    rpcd.start_date,
    rpcd.end_date
FROM rpm_promo rp
JOIN rpm_promo_comp rpc ON rp.promo_id = rpc.promo_id
JOIN rpm_promo_comp_detail rpcd ON rpc.promo_comp_id = rpcd.promo_comp_id
WHERE rp.status = 'A'
  AND rpc.comp_type = '0' -- Simple promotions only
  AND SYSDATE BETWEEN rpcd.start_date AND rpcd.end_date;

6. Official Oracle Resources#

For further reading, consult the official Oracle documentation:

• Oracle Retail Price Management (RPM) User Guide: Promotions
• Oracle Retail Pricing Cloud Service: Promotions Management