My Oracle Support Banner

E-QRY: Error When Using Grid "Find" for a Field Name In Query Manager With Over 9 Records are Added (Doc ID 2946780.1)

Last updated on OCTOBER 06, 2023

Applies to:

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

Symptoms

In Query Manager after adding nine records, when using the grid "FIND" link
in the last record and typing anything to search for, and click ok, getting the following
message or the appserver session crashes. The message happens regardless of which record is the last record:

 

Message
Search string not found. (126,40)
The specified value was not found in any visible field of any row of the
current scroll.

 

The issue can be reproduced with the following steps:
1. Create a query that includes at least 9 records, like the following record examples:
ADM_APPL_RCR_CA
ADM_APPL_PROG
ADM_APPL_DATA
AID_YR_CAR_TERM
INST_CONTROL
STDNT_AID_ATRBT
ISIR_CONTROL
INST_STUDENT
INST_PARENT

NOTE: Join the records as needed with the recommended join.

2. Save the query as a public query

3. Then on the Query tab open the last record (i.e. "INST_PARENT" record) and use the "Find" link in the grid to search for a field name and observe the behavior.
 


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.