My Oracle Support Banner

In the Supply Chain Workbench, Onhand Quantities Pegged To Demands Are Not Honoring Minimum Remaining Shelf Life (MRSL) Days (Doc ID 2983645.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

Item A is lot controlled and has On Hand (1,092) available in a specific lot (LOT123). The expiration of the lot is 28-AUG-2023 00:00:00. The Minimum Shelf Life Days for the item is 49 days, but when looking at the pegging information for the lot, it is being used to meet sales order demand.

Org Item Order Type Sugg Due Date Lot Qty Expiration Date  
PRD:ABC A On Hand 24-JUL-2023 LOT398 228 13-AUG-2023  
PRD:ABC A On Hand 24-JUL-2023 LOT123 1092 28-AUG-2023 <<< Pegging data below
PRD:ABC A On Hand 24-JUL-2023 LOT456 773 23-AUG-2023  







(-) Pegging for A/PRD:ABC Qty 1092 on 24-JUL-2023 00:00:00 (On Hand)
   (+) A/PRD:ABC Qty 198 Pegged Qty 0 on 24-JUL-2023 00:00:00 (Safety Stock)
   (+) A/PRD:ABC Qty 180 Pegged Qty 113 on 24-JUL-2023 23:59:00 (Sales Orders 1343093.ABC_RETAIL.ORDER ENTRY(1.1))
   (+) A/PRD:ABC Qty 24 Pegged Qty 24 on 24-JUL-2023 23:59:00 (Sales Orders 1342939.ABC_RETAIL.ORDER ENTRY(5.1))
   (+) A/PRD:ABC Qty 600 Pegged Qty 534 on 24-JUL-2023 23:59:00 (Sales Orders 1341576.ABC_RETAIL.ORDER ENTRY(1.1))

In the Items form of the Supply Chain Workbench, the Minimum Shelf Life is 49

The expectation is that the a lot that is scheduled to expire in less than 49 days should not be used ot meet sales order demand on 24-JUL-2023

The issue can be reproduced at will with the following steps:

  1. Create an item in Inventory with the following attributes:
    1. Lot Expiration Control = User-defined
    2. Shelf Life Days = 30
    3. Lot Control = Full Control
    4. Starting Prefix = BF
    5. Starting Number = 1
    6. Safety Stock Method = MRP Planned %
    7. Safety Stock Bucket Days = 90
    8. Safety Stock Percent = 1000
    9. Preprocessing Lead Time = 0
    10. Processing Lead Time = 1
    11. Postprocessing Lead Tie = 0
  2. Generate 3 Lot Numbers with expiration dates
    1. BF00001 - 13-AUG-2023
    2. BF00002 - 28-AUG-2023
    3. BF00003 - 29-AUG-2023
  3. Perform receipt transactions into each of the lots
    1. BF00001 - 228
    2. BF00002 - 1092
    3. BF00003 - 773
  4. Create forecast demand
    1. 25-JUL-2023 - 180
    2. 26-JUL-2023 - 24
    3. 27-JUL-2023 - 600
  5. Assign the item to a Make At sourcing rule and associate with an Assignment Set
  6. Run the Planning Data Collection
  7. Create an Item Simulation Set and set the Minimum Remaining Shelf Life Days to 49 for the item
  8. Define plan with the Item Simulation Set attached
  9. Set the following profiles:
    1. MSC: Respect Minimum Remaining Shelf Life Days to Yes
    2. MSC: Anchor date for calculating remaining shelf life to Arrival Date
  10. Run the plan



Cause

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
Symptoms
Cause
Solution
References


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