White Circle Indicator Search Querying Where Indicator Is Null rather than 'W' (Doc ID 401433.1)

Last updated on SEPTEMBER 02, 2014

Applies to:

Oracle Transportation Management - Version: 5.0
This problem can occur on any platform.

Symptoms

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.

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