My Oracle Support Banner

Build Shipment Set Action Causes Exception (Doc ID 2488811.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Sourcing Cloud Service - Version 18 and later
Information in this document applies to any platform.


When attempting to build a shipment set using a saved query ans exception occurs in the SELECT over the SHIPMENT table.

Move Right
Opened Folder An Undefined Error Has Occurred. Please Try Again Later.
Opened Folder An Undefined Error Has Occurred. Please Try Again Later.

TParentObject (type=PShipmentSetData, pk = TCJ.SHIPMENT SET TRANSPORT) is adding child PShipmentSetDData ... [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)']

[000442] [SQL_STATEMENT] select distinct shipment_gid from shipment s,rate_geo r where s.rate_geo_gid = r.rate_geo_gid and r.domain_name = <domain> and s.shipment_gid in(select shipment_gid from shipment where 1=? and (SH.SHIPMENT_XID LIKE '01020%') AND (SH.SHIPMENT_TYPE_GID=STP.SHIPMENT_TYPE_GID) AND (SH.PERSPECTIVE='B') AND (STP.SHIPMENT_TYPE_XID IN ('TRANSPORT')) AND (STP.SHIPMENT_TYPE_XID!='NON FREIGHT RELATED CHARGE') and transport_mode_gid in ('AIR')); [1]

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

1) Shipment Management > Shipment Management > Buy Shipments. Locate an existing shipment where Shipment Type = TRANSPORT and create a Saved Query.

2) Sourcing > Historical Shipments > Shipment Set Criteria.Create a new Shipment Set Criteria using the saved query where Mode Profile ID = AIR, Shipment Type = LTL,

3) Sourcing > Historical Shipments > Shipment Set Criteria > Actions > Build Shipment Set > Build Shipment Set. Set Run Job in Background = 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.