RPLEXT Appears To Be Comparing WH Inventory In EACH To Store Need In PACK, And Fails To Create ROQ (Doc ID 2918054.1)

Last updated on DECEMBER 26, 2022

Applies to:

Symptoms

In at least two locations in the RPLEXT code, the system is taking STORE_NEED (packs) and comparing it against NET_INVENTORY in the WH (each) to determine if need > available. Since need is pack value, it is smaller by factor of pack_qty than available on WH.
Unable to create ROQ as RPLEXT is comparing the warehouse inventory in each store need 

Steps to recreate: 

Dynamic Replenishment (Due_Order Processing is N):

1. Create an Approved item.
2. Create an Approved Simple Pack for the Item with component qty = 4.
3. Range both the Component Item and Simple Pack to a Warehouses and 2 Store.
4. Create Daily Forecasts for the Store.
5. Ensure that component item has some inventory.
6. Put the item on Replenishment
a. Put the store on Constant WH replenishment every day with Replenishment order Control = 'Manual' (M). Set the Simple Pack up as it's primary replenishment Pack. The Source WH I'll refer to as WH A.
b. Put WH A on Dynamic WH replenishment. Set the Simple Pack up as it's primary replenishment Pack.
7. Run RMS Replenishment batches
8. Observe that ROQ generated is very less or 0 as compared to actual store need. This is because program seems to be comparing store_need defined in terms of pack with net inventory defined in units.

Time Supply (Due_Order Processing is Y and N):

1. Create an Approved item.
2. Create an Approved Simple Pack for the Item with component qty = 3.
3. Range both the Component Item and Simple Pack to a Warehouses and 2 Store.
4. Create Daily Forecasts for the Store.
5. Ensure that component item has some inventory.
6. Put the item on Replenishment
a. Put the store on Constant WH replenishment every day with Replenishment order Control = 'Manual' (M). Set the Simple Pack up as it's primary replenishment Pack. The Source WH I'll refer to as WH A.
b. Put WH A on Time Supply WH replenishment. Set the Simple Pack up as it's primary replenishment Pack.
7. Run RMS Replenishment batches
8. Observe that ROQ generated is very less or 0 as compared to actual store need. This is because program seems to be comparing store_need defined in terms of pack with net inventory defined in units and re-computing the incorrect order_qty.

Cause

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