My Oracle Support Banner

Using "Not One Of" In A Saved Query Does Not Return The Correct Results (Doc ID 468633.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

-- Problem Statement:
When entering search criteria for orders that are not in the three planned final statuses
(planning_planned-final, planning_executed-final, planning_executed-partial)the system still
displays orders in these statuses.

-- Steps To Reproduce:
log in OTM
Click on Order Management
Click on Order Release
Click on Order Release

Search Criteria
Under STATUS;
Planning NOT ONE OF
planning_final
executed_final
executed_partial

Click search
Results will still contain orders in the above statuses.

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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