In the Oracle Retail suite, physical inventory is tracked in the Merchandising System (RMS), but the value of that inventory to the consumer is managed by a specialized engine: Oracle Retail Price Management (RPM) (or the modern Oracle Retail Pricing Cloud Service).

Before diving into complex promotional algorithms, you must understand the foundational math of retail pricing. This guide explains the unbreakable relationship between Cost and Retail, and how Initial Markup (IMU) guides buyers during item creation.

1. The Cost-Retail Relationship#

Every sellable item in Oracle Retail possesses two distinct values at any given location:

1. UNIT_COST: What you paid the supplier (often tracked as Weighted Average Cost).
2. UNIT_RETAIL: What you ask the customer to pay.

The absolute difference between these two numbers is your gross profit per unit. If a shirt costs $10 and retails for $25, your gross profit is $15. However, retailers rarely look at absolute dollars when planning thousands of items. They use margin percentages.

Markup vs. Margin

Though often used interchangeably in conversation, these are mathematically distinct:

• Markup %: The profit as a percentage of Cost. ((Retail - Cost) / Cost) * 100 -> (15 / 10) * 100 = 150% Markup.
• Margin %: The profit as a percentage of Retail. ((Retail - Cost) / Retail) * 100 -> (15 / 25) * 100 = 60% Margin.

2. Initial Markup (IMU)#

When a buyer creates a brand new item in RMS, they must set the Initial Retail Price. How do they know what to charge? They use the Initial Markup (IMU) target.

Every Merchandise Department has a target IMU. This target covers the cost of goods, supply chain overhead, store operating expenses (rent/payroll), and the desired corporate profit margin.

The IMU Formula

If a Department has a Target IMU of 60%, and the buyer negotiates a Base Cost of $10 for a new shirt, RPM calculates the suggested Initial Retail using this formula:

Retail = Cost / (1 - Target Margin %)

Retail = $10 / (1 - 0.60) Retail = $10 / 0.40 Retail = $25.00

The system recommends a starting price of $25.00. The buyer can accept this or override it to hit a psychological price point (e.g., $24.99).

3. Maintained Markup (MMU)#

IMU is a theoretical starting point. However, items rarely sell entirely at full price. To clear inventory at the end of a season, retailers take markdowns.

When the price drops from $25 to $15, the margin shrinks. The actual, realized margin achieved when the item is finally sold at the register is the Maintained Markup (MMU).

MMU % = (Actual Revenue - Actual COGS) / Actual Revenue

A buyer's performance is typically judged on their MMU, not their IMU. If they buy poorly and have to heavily discount goods to sell them, their MMU collapses.

4. The RPM Architecture#

Oracle Retail decouples pricing logic from inventory logic.

• RMS owns the Item, the Location, the Supplier, and the Cost.
• RPM (Retail Price Management) owns the Retail Price, Markdowns, and Promotions.

When a price change is approved in RPM, a payload is sent across the Retail Integration Bus (RIB) to RMS to update ITEM_LOC.UNIT_RETAIL. Simultaneously, RPM generates a payload to send the new price down to the Point of Sale (POS) registers via the store polling systems (e.g., SIM/Xstore).

5. SQL Deep Dives#

Calculating Margin Anomalies

This query identifies items sitting on the shelf where the current retail price provides a margin of less than 10%. These items are essentially being sold at a loss once operational overhead is considered, and either need a price hike or need to be discontinued.

SELECT 
    il.item,
    il.loc,
    ils.unit_cost,
    il.unit_retail,
    (il.unit_retail - ils.unit_cost) AS absolute_profit,
    ROUND(((il.unit_retail - ils.unit_cost) / il.unit_retail) * 100, 2) AS margin_pct
FROM item_loc il
JOIN item_loc_soh ils ON il.item = ils.item AND il.loc = ils.loc
WHERE il.status = 'A'
  AND il.unit_retail > 0
  AND ROUND(((il.unit_retail - ils.unit_cost) / il.unit_retail) * 100, 2) < 10
ORDER BY margin_pct ASC;

6. Official Oracle Resources#

For further reading, consult the official Oracle documentation:

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