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

Last updated on JULY 20, 2024

Applies to:

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

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