My Oracle Support Banner

Saved Query Returns Incorrect Results When a Space is Appended to the Saved Query ID (Doc ID 1393077.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Transportation Management - Version 6.1.0 to 6.3.0 [Release 6.1 to 6.3]
Information in this document applies to any platform.

Symptoms

When attempting to create and use a Saved query the first time, the following issue is seen:

-- Issue
It returns all of the records rather than running executing the saved query

-- Expected Behavior
That when executing the Saved Query, only those records would be returned.

-- What is working
The query will work when executing the query a second time again from the results screen

-- Steps
The issue can be reproduced at will with the following steps.
Logged into an instance running OTM 6.1

1. Navigate to Business Process and Automation > Power Data > Event Management > Saved Queries
2. Create 2 Saved Queries
     SAVED_QUERY
     SAVED_QUERY_SPACE (contains a space at the beginning of the name)
3. Navigate Fleet Management > Power Unit Management > Power Unit
4. Run saved query, SAVED_QUERY, it returns the correct result of 1.
      Note: that the saved query field is populated with the query SAVED_QUERY
5.  Run SAVED_QUERY_SPACE and execute the Saved Query it returns a total of 11 records, or performs and open search.
      Note: that the saved query field is blank at the bottom of the page.
6. Then select SAVED_QUERY_SPACE from the drop down again and execute the saved query it returns the correct result of 1.

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.