Troubleshooting
Problem
Replacing inventory from previously reserved node to a different node does not update Order Line Reservations with the new node in IBM Sterling Order Management
Symptom
Steps to replicate
- Create an item ITEM and three nodes STORE1, STORE2 and STORE3.
- Mark STORE1 and STORE3 as Distribution Center and STORE2 as Store.
- Check the flag Procure/transfer to this node when inventory is not available for STORE2
- Create a sourcing rule SRC_SHP and add STORE3 and STORE1 in sequence (i.e STORE3 with seq 1 and STORE1 with seq 2)
- Create a procurement sourcing rule SRC_SHP and add STORE1 and STORE3 in the sourced from list ( with STORE1 as with seq1 and STORE3 as seq2).
- Adjust inventory for ITEM at STORE1 only.
- With YCD_RESERVATION_REQD flag as Y, create an order from COM with fulfillment type as Shipping and confirm the order.
As a result , Two demands – one RSRV_ORDER against STORE1, and another OPEN_ORDER demand gets created
- Remove the inventory for ITEM from STORE1 and adjust it now at STORE3.
- Reopen the order created in step 7 above in COM and click on Change Fulfillment Options.
- Select the order line and change the fulfillment type to pickup. Search to select STORE2 from available stores. Click on Apply. Click Next.
As a result, Two demands – one RSRV_ORDER against STORE1 and OPEN_ORDER against STORE2 get created.
Expected result is that the RSRV_ORDER demand should get updated against STORE3 as there’s no more inventory at STORE1
Similar behavior is observed when a PICKUP order is created first and the fulfillment type is later changed to Shipping.
Cause
You want to avoid backordered orders.
Diagnosing The Problem
Once a reservation has been created for an order, it is always assumed to be available as a supply for the corresponding order line. The problem in such cases can arise when inventory is silently removed. However, as long as there's an already existing entry in YFS_ORDER_LINE_RESERVATION against one store, order will take that as supply and schedule against it, only to backorder at the time of release
Resolving The Problem
To resolve, invoke a changeOrder during fulfillment summary, with Reset flag at OrderLineReservations. This would delete the entry from YFS_ORDER_LINE_RESERVATION for the previous store and create a new one.
Product Synonym
Sterling Order Management;Sterling OMS;Sterling Selling and Fulfillment Suite;SSFS
Was this topic helpful?
Document Information
Modified date:
10 May 2022
UID
swg21986209