What is RMS Replenishment?

At its core, Replenishment in Oracle RMS is the automated process of keeping stores and warehouses stocked. Instead of buyers manually creating Purchase Orders or Transfers every time stock gets low, RMS calculates the exact required quantity based on predefined rules, sales history, and current inventory positions, and automatically generates the necessary fulfillment documents.

The replenishment module in RMS answers three fundamental questions every single night during the batch run:

1. Does this location need stock? (Trigger condition)
2. How much stock does it need? (Order Quantity calculation)
3. Where should it come from? (Sourcing: Supplier via PO, or Warehouse via Transfer)

The 6 Core Replenishment Methods

RMS supports several distinct replenishment methods. The method you choose depends on the type of item (fast fashion vs. staple grocery, seasonal vs. year-round).

1. Min/Max (Minimum/Maximum)

The most common and easiest method to understand. You define a Minimum threshold and a Maximum threshold. If the Net Inventory drops below the Minimum, RMS generates an order to bring the inventory back up to the Maximum.

• Best for: Staple goods with highly predictable, flat sales (e.g., bottled water, basic white socks).

2. Constant

Similar to Min/Max, but the minimum is effectively the same as the maximum. If the stock drops by 5 units, RMS orders exactly 5 units to replace them.

• Best for: High-ticket items or highly space-constrained displays where exactly $X$ units must always be present.

3. Dynamic

Dynamic replenishment relies on external sales forecasts (typically fed from Oracle Retail Demand Forecasting - RDF). RMS uses these daily sales forecasts, combined with desired service levels (e.g., 98% in-stock probability), to calculate a dynamic minimum and maximum that fluctuates with seasonality.

• Best for: Highly seasonal staple goods (e.g., sunscreen, winter coats).

4. Time Supply

Instead of setting hard unit quantities, you set time limits. For example, "Order when we have less than 7 days of supply, and order enough to last 21 days." RMS uses the sales forecast to convert those "days" into unit quantities.

• Best for: Fast-moving consumer goods (FMCG) where shelf life or warehouse space is a concern.

5. Time Supply - Seasonal

A variation of Time Supply that automatically ramps down inventory as an item reaches its predetermined end-of-life date, ensuring you don't over-order right before a clearance event.

6. Floating Point

A highly specialized method that uses a combination of sales history and complex algorithms to "float" the minimum and maximum points up and down without needing an external forecasting engine.

The Net Inventory Formula

Before RMS can decide if an item needs replenishing, it must calculate the Net Inventory for that item at that location. Net Inventory is not just what is physically on the shelf; it accounts for stock that is already on its way, and stock that is reserved for other purposes.

The fundamental formula evaluated by the reqext (Requirement Extraction) batch is:

If Net Inventory < Minimum Threshold (or Order Point), replenishment is triggered.

The REPL_ITEM_LOC Table

The heart of the replenishment configuration in RMS is the REPL_ITEM_LOC table. Every item/location combination that is on automated replenishment must have an active record here.

Querying Replenishment Setup

Here is a helpful query to find all active Min/Max replenishment setups for a specific department, including their current net inventory to see if they will trigger tonight:

SELECT 
    ril.item,
    ril.location,
    ril.min_stock,
    ril.max_stock,
    (s.stock_on_hand + s.in_transit_qty + s.stock_on_order) AS net_inventory,
    CASE 
        WHEN (s.stock_on_hand + s.in_transit_qty + s.stock_on_order) < ril.min_stock 
        THEN 'WILL_TRIGGER' 
        ELSE 'SUFFICIENT' 
    END AS nightly_batch_prediction
FROM 
    repl_item_loc ril
JOIN 
    item_master im ON ril.item = im.item
JOIN 
    item_loc_soh s ON ril.item = s.item AND ril.location = s.loc
WHERE 
    im.dept = 1000
    AND ril.repl_method = 'MM'
    AND ril.activate_date <= SYSDATE
    AND (ril.deactivate_date IS NULL OR ril.deactivate_date > SYSDATE);