Setting the Limit of the Pivot Grid Result Rows
You use the Max Rows in Pivot Grids field in the PeopleTools options page (PeopleTools, Utilities, Administration, PeopleTools Options) to set the number of rows returned in detail grid or list view (that is obtained by executing the query). The default setting is 100. This setting is applying for component real time search view, Fluid Mode Detail View, and Classic Pivot Grid Detail View.
Image: PeopleTools Options page
This example illustrates the fields and controls on the PeopleTools Options page. The Max Rows in Pivot Grids option is highlighted.
Note: You can specify a negative value for unlimited number of rows, but Oracle PeopleSoft strongly recommends that you don't use unlimited rows for performance reasons.