My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 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

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