One Of, Not One Of, Not Null And Is Null Parameter Options Not Working On Reports (Doc ID 752908.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.03 to 6.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.03, Find that the filters on Report fields such as One of, Not One Of, Is Null or Not Null
are not delivering the correct results
For example, Is Null shows data for records where the specified field value is not null and vice
versa

EXPECTED BEHAVIOR
Expect that the field filters work as expected and defined

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.Log on to OTM and run PUBLIC report such as Order Summary with the filter such as One of, Not
One of, Is Null and Not Null on the Order Base ID field
2. See that Is Null filter is not filtering the fields that are Null instead, showing all records

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot filter reports using search criteria

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