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 JANUARY 26, 2018

Applies to:

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

Symptoms

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

Uses are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 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 = 436672410310 item id = 1979464
Item name = 436676540310 item id = 1979583
Org Code = PRD:LHV Org id = 768

A. Ordering more material when they're already over the Max Qty
Item = 436672410310
Org = PRD:LHV
Supplier = DANFOSS LLC
Supplier Site = US-MD-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???

It should be noted in the ASL for this item/org there is a disabled supplier/site called DELPHI AUTOMOTIVE SYSTEMS LLC

B. Not ordering material when below the Min Qty
Item = 436676540310
Org = PRD:LHV
Supplier = DANFOSS LLC
Supplier Site = US-MD-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 = DELPHI AUTOMOTIVE SYSTEMS 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

EXPECTED BEHAVIOR
-----------------------
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

STEPS
-----------------------
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms