Inbound Goods In Transit Query Smarklink on SKU Is Missing Bind Variable
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Management - Version: 6.1.0
Information in this document applies to any platform.
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
(ss1.status_value_gid=sv1.status_value_gid))); PHL, , D [
In looking at this, the query is looking for the following variables:
However, the following is showin for the variable values, leaving out the
PHL, , D
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