My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Transportation Management - Version 5.5.03 to 6.0 [Release 5.5 to 6]
Information in this document applies to any platform.
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


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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