«

»

Nov 26

Print this Post

Maximum number of records found

Maximum number of records found matching specified key(s)

I had been into an issue in past which was related to a warning message when tried to open the component Careers (Candidate Gateway). While trying to open the “careers” component, a warning message was poping up everytime stating “Maximum number of records found matching specified key(s)”. Later, it was figured out that due to the drop down limitation to fetch data upto 300 rows only, this message was coming. Below is the problem description and details of resolution applied.

Issue: Message was poping up on Careers component stating “Maximum number of records found matching specified key(s)”.
Reason: We had over 300 rows in PS_JOB_FAMILY_TBL. As a result, the Careers component was throwing the following message.
Resolution: Drop down can be changed to a prompt.

Resolution details:

The sub page HRS_CE_E_PREFS_SBP has a reference to Job Family as a drop down list item. The drop down list item can only fetch upto 300 number of items. If the list items exceed this limitation, a message is given that not all items could be displayed.

To fix the problem the drop down can be changed to a prompt.

1. Delete the drop down HRS_APP_JOBFAM.JOB_FAMILY
2. Insert an edit box in grid HRS_APP_JOBFAM (level 2)
3. Set the page field properties

Record name: HRS_APP_JOBFAM
Field name: JOB_FAMILY

Permanent link to this article: http://alokbhardwaj.com/oracle-peoplesoft/2008/11/26/maximum-number-of-records-found/

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>