Increasing the Number of Rows in a Grid

You may want to limit the number of rows that appear in grids on high-volume inquiry or worksheet pages, such as the worksheets for payments, maintenance, transfer items, drafts, and direct debits. Oracle delivers PeopleSoft Receivables with a default of 100 rows in the grid—the maximum number of rows that can be contained in the grid at one time. This is referred to throughout this documentation as a chunk or grouping of rows.

Use the Installation Options - Receivables page (INSTALLATION_AR) to define the maximum numbers of rows that appear at one time in inquiry and worksheet grids.

Navigation:

Set Up Financials/Supply Chain > Install > Installation Options > Receivables

Increase or decrease the default of 100 rows that appears in a grid (chunking) by changing the value in the Max Number of Rows in Scrolls field. The change may affect performance, but the impact depends on other factors. The greater the number of rows in the grid, the longer the time for the pages to appear. Experiment to find the number that works best.

The limit of rows in a grid works in conjunction with the up and down arrow buttons on the pages. Given the default of 100 rows, if the search criteria returns 100 or fewer rows from the database, they are all available in the grid and the arrow buttons are invisible. If the search criteria returns more than 100 rows, use the arrow buttons to view the different chunks of 100 rows in the grid.