ePerformance - Template Definition throws Maximum number of records found matching specified key(s) -- others not included in list. (4,2) error for 300+ Section Definitions in the System (Doc ID 2168867.1)

Last updated on AUGUST 11, 2016

Applies to:

PeopleSoft Enterprise HCM ePerformance - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other Issue with ePerformance

When the system contains more than 300 section definitions. In Template definition >> Structure tab, the section drop down box is not able to load all the sections and produces the below warning message.

ERROR
-----------------------
Maximum number of records found matching specified key(s) -- others not included in list. (4,2) When performing a Lookup, the database returned more rows than can be accommodated in the list box. Use a Partial Key value or Advanced Search to limit the number of rows returned or specify more characters to further qualify the key value.


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

1. Create 301 sections in e Performance
2. Navigate to Main Menu >> Set Up HCM >> Product Related >> ePerformance >> Document Structure >> Template Definition. Select a template definition.
3. Go to structure tab.
4. Warning message is shown.

Maximum number of records found matching specified key(s) -- others not included in list. (4,2)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms