Dynamic Replenishment – Negative Values For Order ROQ On REPL_RESULTS_STG (Doc ID 2968589.1)

Last updated on AUGUST 18, 2023

Applies to:

Symptoms

On : 16.0.3 version, Other

ACTUAL BEHAVIOR
---------------
Dynamic Replenishment – Negative Values for Order ROQ on REPL_RESULTS_STG

When using Dynamic replenishment, if the calculated value for ORDER_ROQ for a store is negative on REPL_RESULTS_STG, it should be written to the table as 0. Instead the actual negative value is being used. This is causing the Order Point and Order Up To Point on REPL_RESULTS for the warehouse to be understated. If the number of stores with a negative value and/or the size of those values is sufficient it will drive the sum of all stores to a negative value, resulting in a 0 Order Point/Order Up To Point for the warehouse instead of some positive value representing the stores that will actually need stock.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Set up an item for Dynamic replenishment to a warehouse. This includes configuring the stores for replenishment sourced from that warehouse and ensuring there are sales forecasts for those stores.
2. Select or setup data so that the Order ROQ on REPL_RESULTS_STG will be calculated as a negative value
3. Run replenishment batches.
4. Note that on REPL_RESULTS_STG for the item(s) identified in step 2 that the ORDER_ROQ is a negative value instead of 0
5. Note that the ORDER_POINT and ORDER_UP_TO_POINT for the warehouse on REPL_RESULTS reflects the inclusion of that negative value(s) as a results of summing REPL_RESULTS_STG.ORDER_ROQ

Cause

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