Working with Large Requisitions

Chunking controls the number of lines that the system initially loads when you open a requisition. Using chunking functionality, you can initiate an advanced requisition line search that eliminates system processing times for a requisition with a large number of lines and provides a quick and easy method to retrieve specific lines in the requisition.

Note: A chunk is not the same as a page full of data. It represents all of the rows that are in the scroll at a given point in time.

When you open an existing requisition, if the number of requisition lines exceeds the chunking limit defined on the Installation Options page for Purchasing and the new PO Installation setting specifies to display the Advanced Line Search first, the system does not initially load requisition lines. Instead, a search page appears that you can use to view and load specific lines, based on criteria that you specify.

The search can either pull lines directly into the Maintain Requisition page or show the results in a temporary summary grid from which you can select individual lines to load into the page.

Note: You can also access the Advanced Line Search page using the Search for Lines link on the Maintain Requisitions page.

  1. Open the Installation Option page for Purchasing. Installation Options - Purchasing Page

  2. Specify the maximum number of rows to retrieve for requisition searches.

  3. Select the Display Advanced Line Search Page option to define the initial advanced search behavior when the maximum number of rows has been exceeded for requisition lines.

  4. Search for a requisition with lines that exceed the maximum number of rows to retrieve.

    Note: If the requisition lines do not exceed the maximum number of rows, the system accesses the Maintain Requisition page and does not initiate the advanced search.

  5. Define search criteria to limit the search results and click the Search button.

  6. Select the requisition lines that you want to load into the Maintain Requisitions page.

  7. Click the Retrieve Selected Items link.

The system loads the lines and you can now maintain requisition and schedule lines.

Page Name

Object Name

Navigation

Usage

Maintain Requisitions –Advanced Line Search

REQ_HDR_CHUNK

Purchasing > Requisitions > Add/Update Requisitions

Define advanced search criteria for requisition lines.

Maintain Requisitions- Advanced Line Search

Use the Advanced Line Search page to define requisition line criteria

Navigation:

Purchasing > Requisitions > Add/Update Requisitions

This example illustrates the fields and controls on the Maintain Requisitions- Advanced Line Search. You can find definitions for the fields and controls later on this page.

 Maintain Requisitions - Advanced Line Search page

Use the Advanced Line Search page to define requisition line criteria on which to base the search. After defining search criteria, click the Search button to display the lines in the Search Results grid. The results include information about the line and additional actions that you can perform to load the lines. Select the More Details tab to see more information about the requisition lines.

You can also load the lines into the Maintain Requisition page by clicking the Search and Load button.

You can use all of the fields that are available for entry in the Search for PO Lines section and the Chartfields grid to filter the search results. The prompts that are available for the item ID, ship to location, supplier item ID, category, supplier’s catalog, manufacturer ID, manufacturing item ID, and contract ID are for distinct values within existing requisition lines. The system loads a requisition line if at least one of the line’s schedules matches any schedule criterion entered.

The Chartfields grid displays the ChartFields on the purchase order distribution level. Any combination of ChartField values that you enter must match the same values on at least one distribution line for the requisition line to be loaded. The system loads the requisition line even if other distributions that belong to that line do not match the exact ChartField combination entered

The search and processing options for the Maintain Requisitions - Advanced Line Search page are the same as those for the Maintain Purchase Order - Advanced Line Search page.

For more information about the page field descriptions Working with Large Purchase Orders