Ship Confirming Partial Quantity For Line With Multiple Split Delivery Details Does Not Transfer Reservations To New Line Creating Orphan Reservations (Doc ID 2802475.1)

Last updated on JUNE 06, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Find orphan reservations are created when ship confirming partial quantity for an order line with multiple split delivery details.

For example,
Line 1 for ordered quantity 12.
Line 1 is split in batches of 2 where multiple lines are transacted (i.e. few move orders are transacted to FG and remaining move order are not yet transacted so partial quantity is still in inventory/JOB.)
When ship confirming partial quantity of ordered quantity of 12 the application is creating an orphan reservation.



EXPECTED BEHAVIOR
-----------------------
Expect Orphan reservation should not be created or left but transferred to the newly created order line after delivery detail has been progressed through interface trip stop.



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

1. Customer shows Sales Order and Ordered Item, Packer will split the lines based on the qty to be packed per pallet
2. Transact the move orders
3. Attempt to ship the only 1 line xxxxx - LPN-yyyyy
4. Check reservations 'before' (Line 1.1 reservation)
5. Ship Confirm one line
6. See that first line in the reservation remains with line number 1.1 post shipping
7. SO line 1.1. is closed
8. Standard Identification SQL returns 1 Orphan reservation for i2471362.sql

Changes

Cause

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