Inbound Goods In Transit Query Smarklink on SKU Is Missing Bind Variable (Doc ID 1154363.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.1.0 and later   [Release: 6.1 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to view the Inbound Goods in Transit for a particular sku using the smartlink, no rows are returned. In the logs, it is shown the packaged item variable value is left out even though it exists in the sku. Because of this, not results are found.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM.
2. Go to Shipment Management --> Visibility --> SKU.
3. Search for a SKU which is currently in use.
4. Right click the record to bring up the Smartlink menu and click on "Inbound Goods in Transit".
5. Note 0 results are returned.
6. When looking at the logs, the query below is seen.
select sh.shipment_gid as shipment_gid, sh.shipment_gid from SHIPMENT sh
where (sh.shipment_gid in (select sstop.shipment_gid from LOCATION sstopl,
PACKAGED_ITEM pi, S_SHIP_UNIT_LINE ssul, S_SHIP_UNIT ssu, SHIPMENT_STOP_D
sstopd, SHIPMENT_STOP sstop where (sstopl.location_gid=?) and
(pi.packaged_item_gid=?) and (ssul.packaged_item_gid=pi.packaged_item_gid)
and (ssu.s_ship_unit_gid=ssul.s_ship_unit_gid) and
(sstopd.s_ship_unit_gid=ssu.s_ship_unit_gid) and (sstopd.activity=?) and
(sstop.shipment_gid=sstopd.shipment_gid) and (sstop.stop_num=sstopd.stop_num)
and (sstop.location_gid=sstopl.location_gid))) and (sh.shipment_gid in
(select ss1.shipment_gid from STATUS_VALUE sv1, SHIPMENT_STATUS ss1 where
(sv1.status_value_xid='GOODS_IN_TRANSIT_IN_TRANSIT') and
(ss1.status_value_gid=sv1.status_value_gid))); PHL, , D [

In looking at this, the query is looking for the following variables:
sstopl.location_gid=?
pi.packaged_item_gid=?
sstopd.activity=?

However, the following is showin for the variable values, leaving out the
packaged item:

PHL, , D


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