MRP Plan Run not Providing Correct Use-Up Date For ECO (Doc ID 960334.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle Engineering - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Apr-2012***
***Checked for relevance on 25-Dec-2013***


Symptoms

On 11.5.10.2 in Production:
Users are having problems determining how MRP derives the Use Up Date for an unimplemented ECO.
Consider the following example:

1. Item A is currently at REV 01 and there's a change coming out that will not change the item name (ie form, fit, function is not applicable here) but only the REV level to 02.

Onhand = 25
Demand = 63 (All demand is currently past due)
One outstanding supply Purchase Order for qty = 100.

2. They create an ECO which is not implemented but is scheduled as they want to see the Use Up Date which is determined by the MRP Plan run

3. Run the MRP plan

4. Go back to the ECO and select the effective date

5. This opens a window which shows them the MRP calculated Use Up Date. However they see a value here equal to the plan horizon date of the MRP plan

6. Cancel the Purchase Order so that demand exceeds onhand and no other supplies are available

7. Rerun the MRP Plan

8. Note the ECO Use Up Date is now the current sysdate plus 1 day which is what they expected to have happen

EXPECTED BEHAVIOR
Expect the Use Up Date to only take into account on hand and demand only. It's not expected that the open purchase order will be included

STEPS
The issue can be reproduced at will with the following steps:
1. Create unimplemented ECO which is open, scheduled, but not implemented
2. Run the MRP Plan
3. Review the effectivity date in the ECO and see the plan horizon (ie plan end date)
4. Cancel the one open PO for the item
5. Rerun the MRP Plan
6. Now the ECO Use Up Date is current sysdate plus 1 day which is what they expected to have happen

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