Reservation Remains for Closed Line After Partial Shipped (Doc ID 2100063.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

After Line was split by partial shipped, the reservation record remained in the MTL_RESERVATIONS table for the CLOSED line.

* The Staging sub inventory is set to non-reservable.

Expected Behavior
Remove reservations upon shipment.

Steps
1.Create Order
Quantity：3

2.Manual Reservation
Quantity:1

3.Pick Release
Prior Reservations Only:Checked
Autocreate Delivery:No
Auto Pick Confirm:No

4.Manual Reservation
Quantity:1

5.Pick Release
Prior Reservations Only:Checked
Autocreate Delivery:No
Auto Pick Confirm:No

6.Manual Reservation
Quantity:1

Delivery status is below:
DDID       Line Status                      Move Order Number
---------------------------------------------------------
3640064 Released to Warehouse XXXXX
3640065 Released to Warehouse YYYYY
3640066 Ready to Release

7.Transaction Move Order
Check Move Order Number:XXXXX & YYYYY line and press 'Transact' button.

Delivery status is below:
DDID       Line Status                   Delivery Move Order Number Line LINE_ID
------------------------------------------------------------------------------------------------
3640064 Staged/Pick Confirmed 171333 XXXXX                       1.1 5343959
3640065 Staged/Pick Confirmed 171333 YYYYY                        1.1 5343959
3640066 Ready to Release                                                       1.2 5343961

8.Ship Confirm
Then the issue occur. The Reservation for Line: 5343938 (Quantity:1)
remained in MTL_RESERVATIONS table.

MTL_RESERVATIONS
DEMAND_SOURCE_LINE_ID LINE Quantity
-----------------------------------------
5343959 1.1 1

=> The DEMAND_SOURCE_LINE_ID and LINE_NUM should be updated as 5343961 and 1.2.

Cause

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