E-PPR: Error 'Maximum Number Of Records Found Matching Specified Keys' After Download Grid Completes (Doc ID 2200869.1)

Last updated on NOVEMBER 04, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

If there is a display control field of type Drop Down List in a grid, and the field's value is blank, then after a Download Grid is triggered, the parent page will show 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.

The error doesn't prevent the Excel file from generating or downloading, but users will see this error after the Excel file is downloaded, leading to confusion.

The issue can be replicated in-house by enabling "Download Grid" grid header button on a delivered HCM page at: Manager self service > Time Management > Report Time > Timesheet.  But the backend table PS_TL_TRC_TBL for the Related Control Field must have over 300 rows for the error to trigger.



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