My Oracle Support Banner

VMI - Some Item/Orgs Below Min Value Are Not Recommending Replenishments And Some Are Recommending Replenishments When Above The Max Value (Doc ID 2353609.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Collaborative Planning - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, VMI Replenishment/Release in PROD and TEST

Uses are on 12.2.4 and have applied VCP Cum Patch - 19549533 - MANDATORY PATCH. They are using CP with supplier VMI. They are running into 2 intermittent issues (intermittent as it does not happen for all VMI items)

1. There are item/orgs where the item is above its Max Qty but there's still a suggested replenishment quantity
2. There are item/orgs where the item is below its Min Qty but there's Null suggested replenishment quantity

Example data:
Item name = 436672410 item id = 197946
Item name = 436676540 item id = 197958
Org Code = PRD:LHV Org id = 768

A. Ordering more material when they're already over the Max Qty
Item = 436672410
Supplier Site = US-BALTI-02C
Min qty = 97
Max qty = 110
On hand = 124
On order = 73
Even though they're over the Max Qty there's still a
Replenishment Date = 20-OCT-2017
Suggested Replenishment Quantity = 96
Replenishment Quantity = 96
Why is there a suggestion to order more???

B. Not ordering material when below the Min Qty
Item = 436676540
Supplier Site = US-BALTI-02C
Min qty = 15
Max qty = 17
On hand = 4
Replenishment Date is Null
Suggested Replenishment Quantity is NULL
Replenishment Quantity is NULL
Why is there no replenishment here???

Something found when looking at this same item/org in the vertical view there's and old Order Type = Replenishment with Actual Date = 28-OCT-2016 for an old Supplier = COMPANY LLC qty = 16 with Receipt Date = 24-JAN-2017. This supplier is NOT on the sourcing rule and when they try to query the supplier in CP it does not show up. It's believed this old replenishment is potentially causing the problem but it's not known how to get rid of them

Expect no replenishment suggestions for items/orgs where they're above the Max Qty
Expect replenishment suggestions for items/orgs where they're below the Min Qty

The issue can be reproduced at will with the following steps:
1. Run Data Collections and VMI Engine in CP
2. Review VMI in the Planning tab
3. Find items/orgs with sugg repl qty when they're above the max qty
4. Find items/orgs with no sugg repl qty when they're below the min qty


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

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