My Oracle Support Banner

Build Shipment Set Action Causes Exception (Doc ID 2488811.1)

Last updated on NOVEMBER 14, 2019

Applies to:

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

Symptoms



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

ERROR
-----------------------
Error
Move Right
[000442]
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]

STEPS
-----------------------
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.


Cause

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
Symptoms
Cause
Solution
References


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