Investment Buy Quantities Inflated When Added To Replenishment PO (Doc ID 2901272.1)

Last updated on OCTOBER 12, 2022

Applies to:

Symptoms

When investment buy quantities are added to a replenishment PO they are inflated based on the number of locations ranged to the item. For example, IB_RESULTS may show a quantity of 1000 for a WH and REPL _RESULTS shows 500 for the same warehouse. If another location (even a store) is ranged to the item then ORDLOC shows a quantity of 2500 instead of the expected 1500. If there are two locations ranged in addition to the warehouse  then the ORDLOC quantity is 3500 instead of the expected 1500. This appears to be caused by an error in the rplbld batch.

Steps To Recreate:
1. Configure system, supplier and warehouse parameters for investment buy functionality
2. Configure dynamic replenishment for daily review for an item with at least ONE warehouse and TWO stores ranged. Store replenishment for BOTH stores should be configured to source the item from the warehouse being used in the test. Warehouse replenishment will be from the supplier site. Set order control at semi-automatic for the warehouse and BOTH stores.
3. Populate daily item forecast for BOTH stores AND the warehouse.
4. Create and approve a cost change for the warehouse location for vdate +1. It should be a cost increase of sufficient size to trigger the investment buy functionality based on the parameters being used.
4. Run replenishment and investment buy batches
5. See that the quantity on the PO produced is greater than expected based on the quantities in IB_RESULTS and REPL_RESULTS.

Cause

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