One Of, Not One Of, Not Null And Is Null Parameter Options Not Working On Reports
(Doc ID 752908.1)
Last updated on JULY 20, 2024
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 |