Inconsistency In Review Time Forecast Using RMS Dynamic Replenishment When Service Lvl = SS (Doc ID 2905748.1)

Last updated on OCTOBER 28, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR

---------------

When performing Dynamic Replenishment from the Supplier to Warehouse, the REPL_RESULTS_STG.REVIEW_TIME_FORECAST does not appear to be the same value used when calculating REPL_RESULTS_STG.SAFETY_STOCK.

It appears the Review Time Forecast used for calculating Safety Stock begins one day after the Review Time Forecast that is calculated and stored on REPL_RESULTS_STG. Per the Replenishment documentation, the Simple Sales Safety Stock is calculated as Review Time Forecast * (1 - Safety Stock). What you see is that the REPL_RESULTS_STG.REVIEW_TIME = 130, but when the Simple Sales Service Level = 90%, instead of a SAFETY_STOCK = 13, it is calculated as 14 (which is the Review Time Forecast if using a starting point of 1 day later).

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Setup an Item on Dynamic WH Replenishment from the Supplier. Set it to be reviewed every day. Set Service Level Type = Simple Sales and Service Level = 90%.

2. Setup the item on WH to Store Replenishment, linking the Store to the WH from Step #1. Set it to be reviewed every day.

3. Create Forecast records on DAILY_ITEM_FORECAST for the item/store in Step #2. Make sure each day’s forecast is different (for me, I just multiplied the day by 10 (i.e. Jan 1 = 10, Jan 2 = 20, etc).

** You can see the setup of the items in the attached document

4. Run Replenishment batches

5. Our result is that the Review Time was calculated using vdate + 1 + Supp LT + Pickup LT + WH LT (in the attachment it was using the Forecast on 13-8-22 for 130 units). BUT, the Safety Stock appeared be calculated using the Forecast on 14-8-22 for 140 units.

Changes

Cause

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