My Oracle Support Banner

E-AD/E-QRY: The 2-Tier Query Tool Does Not Display the Correct Boolean Value on the Logical Column, in the Criteria Tab, After it is Changed (Doc ID 2742508.1)

Last updated on JANUARY 10, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

The 2-Tier Query Tool, opened from Application Designer, is not Displaying the correct boolean value on the Logical Column, in the Criteria tab, after it is Changed.

The issue can be reproduced with the following steps:
1. Open Application Designer.
2. Select Go > Query.
3. Open a query.
    E.g.: File > Open > ACA_FULL_PART_TIME
   
4. Click on the Criteria tab:
5. Double click on one of the values in the Logical column and modify it (e.g.: if it was 'AND', modify it to 'OR').
6. Save the query.
7. Click on the SQL tab at the top, and, then, back on the Criteria tab.
    Note that the value reverted back to 'AND'.

Changes

 

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
Changes
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.