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:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
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).
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document