My Oracle Support Banner

E-FLUID: / E-PIA: Configurable Search is not Returning All Rows Matching Search Criteria in HCM (Doc ID 3037737.1)

Last updated on JULY 29, 2024

Applies to:

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

Symptoms

Configurable Search is not working for the User Profiles component. After setting up the configuration, when searching for a User ID beginning with 'P', for example, more than one result was expected.

The issue was reproducible in the customer site with the following steps:

1. Using a fresh demo instance, open Application Designer.

2. Open the record PSOPRDEFN_SRCH.

3. Save a copy of the record and call it MY_OPRDEFN_SRCH.

4. Add the field JOBCODE.

5. Change the SQL definition to:

20. Run a simple search like User ID begins with P. The only result that is ever returned is PS.



Changes

Upgraded to PeopleTools 8.60. 

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


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