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!

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