White Circle Indicator Search Querying Where Indicator Is Null rather than 'W'
Last updated on SEPTEMBER 02, 2014
Applies to:Oracle Transportation Management - Version: 5.0
This problem can occur on any platform.
When you run a query for shipments using a criteria of indicator = 'WHITE', the sql query that is run for the search is not correct:
select sh.shipment_gid, sh.shipment_gid from SHIPMENT sh, SHIPMENT_TYPE stp where (sh.indicator is null) and (sh.perspective='B') and (sh.shipment_type_gid=stp.shipment_type_gid) and (stp.shipment_type_xid!='NON FREIGHT RELATED CHARGE')
where (sh.indicator is null) should be (sh.indicator='W')
This is a problem when the indicator on a shipment has been set to a color such as 'RED' and is then set to 'WHITE'- no shipments are returned because in the database, the value for the field is 'W', but the finder screen is looking for a null value.
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