Copy Quantities Buy To Sell Shipment Fails
Last updated on MARCH 08, 2017
Applies to:Oracle Transportation Management - Version 5.5.04.06 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2011***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms