Copy Quantities Buy To Sell Shipment Fails
(Doc ID 942054.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 5.5.04.06 and later
Information in this document applies to any platform.
If the quantity on a buy shipment is changed, the action to copy the quantities to a related sell shipment fails.
OTM displays an error message that there is not a 1:1 relationship between the ship unit lines, despite both the Buy and the Sell Shipments have 1 ship unit and 1 ship unit line.
This is the query generated by OTM as seen in the SQL Log:
select distinct s_ship_unit_gid, s_ship_unit_line_no, ship_unit_line_no from s_ship_unit_line where s_ship_unit_gid like '<Shipment_ID>' order by ship_unit_line_no
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