Time Supply Replenishment Providing Incorrect Or Incomplete Values In REPL_RESULTS (Doc ID 2779652.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

When reviewing the results of Supplier->WH Time Supply Replenishment on REPL_RESULTS, there appears to be a few columns giving incomplete results.

The expectation is
ORDER_POINT :- MIN of FORECAST SALES up to next review period

ORDER_UPTO_POINT - MAX of FORECAST SALES

Values that are not provided that are highly relevant are:
MIN_SUPPLY_DAYS_FORECAST.
MAX_SUPPLY_DAYS_FORECAST.
TIME_SUPPLY_HORIZON_FORECAST.

Actual result

These columns are not populated
MIN_SUPPLY_DAYS_FORECAST.
MAX_SUPPLY_DAYS_FORECAST.
TIME_SUPPLY_HORIZON_FORECAST.

The ORDER_POINT and ORDER_UPTO_POINT are SAME.

Steps to reproduce: 


1. Setup an item on Constant Replenishment for WH->Stores for every day review.
2. Setup an item on Time Supply Replenishment for Supplier->WH for the WH used in Step 1.
  a. Check Add Lead Times Ind when setting up.
  b. Ensure the WH has no or low inventory so that it triggers an ROQ.
  c. Setup for Tuesday and Saturday Replen Review
3. Setup delivery schedule for the Supplier->WH for every Thursday
4. Have daily forecasts in RMS for the item/stores from step 1.
5. Run replenishment batches
6. Check REPL_RESULTS table related to the mentioned columns.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.