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

Last updated on MAY 06, 2022

Applies to:

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

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