Copy Quantities Buy To Sell Shipment Fails (Doc ID 942054.1)

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***


Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms