E-QR: Query Viewer Use Enter Key for Invalid Prompt Value Then "View Results" does Nothing (Doc ID 3041666.1)

Last updated on FEBRUARY 05, 2025

Applies to:

Symptoms

Entering and invalid prompt value in Query Viewer and clicking the "enter" key followed by then correcting the value and clicking "View Results" causes the Query not to run and nothing happens. Then the Query must be rerun.
 
Correcting an invalid value and then clicking "View Results" should then process query normally instead of do nothing.
 
 
The issue can be reproduced with the following steps:
1. Reporting Tools > Query > Query Viewer

2. Run a Query that has a required prompt value.

3. After an erroneous value is entered for a Query prompt using "Enter" key, then replacing the invalid value with a valid value and pressing "View Results" 

4. Observe no results appear and it is then non-functional and must be rerun from the beginning

 

Cause

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