E1: 34: R3482 Generates Incorrect Decrease message On Existing Rate Schedule (Doc ID 1994021.1)

Last updated on DECEMBER 16, 2015

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

E1 9.1 / R3482 MRP

When a rate scheduled item has a minimum order quantity defined that is greater than the value order policy (which functions like a safety stock for
a rate scheduled item), MRP (R3482) will suggest that the existing rate schedule be decreased to a quantity below the minimum order quantity.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a rate type item with the following settings:
     a.  Item Branch/Plant P41026 Additional System Info form:
          Order Policy Code = 5
          Value Order Policy = 600
          Planning Code =2
          Planning Fence Rule = F
     b.  Item Branch/Plant P41026 Quantities form:
          Minimum Reorder Qty = 1000
     c.  Line Item Relationship (P31093)
          Default Period = 2
     d.  Forecast (P3460)
          Request date = 3/6/2015,  Quantity = 500
     e.  No inventory on-hand for the item.

2. Run R3482.  Data select on the branch plant and item.
    Planning horizon:  1 past due period, 30 days
 
3. Review the Time Series P3413 and Messages P3411.  All row calculations/buckets are correct.
    The system creates two order messages (+RS) for the item.
    Total demand for the item is 1100 EA  – 600 from the Value Order Policy (safety stock) and 500 from forecast.  
    Because the system can only suggest create rate messages with a minimum quantity of 1000, the planning is correct.

4. Process the second create rate message to create a firm rate schedule.  
    ** It is important that the rate schedule message processed is the one that exists in the same period as the actual demand (in this example, the forecast).  

5. Run R3482 again.
    Review the Messages P3411 and Time Series P3413.  The rate schedule previously created via the MRP message now has a decrease message.
    This is incorrect as the system should never suggest that a rate schedule be decreased to a quantity less than the minimum order quantity.

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