Incorrect Results Displayed When Executing Saved Query Within Advanced Layout (Doc ID 2170114.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
An advanced layout has been created with a buy shipment table. When clicking to execute a saved query in the buy shipment table within the advanced layout, the results returned are for all shipments. If you click to execute the query again (a second time), the correct results are displayed. The same query, when executed from the default buy shipment finder set screen returns the correct results as well.

EXPECTED BEHAVIOR
-----------------------
It is expected that the query return only results specified by the conditions in the query.

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Open an advanced layout that contains a buy shipment table
2. From the Buy Shipment table, select a saved query.
Ex: A saved query that is querying for shipments with statuses secure_resources_not_started and secure_resources_withdrawn.

3. Click the 'Play' button to execute the saved query.
4. Shipments with all other statuses will be displayed. You will find shipments with status SECURE_RESOURCES_ACCEPTED among the results.
5. Click the 'Play' button to execute the saved query again.
6. The correct results will be displayed as only shipments with status secure_resources_not_started or secure_resources_withdrawn are displayed.

Cause

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