Describing Requisition Close Criteria

To understand how the Close Requisitions process functions, you must know the criteria that the process uses to close a requisition. The process references the settings and statuses of several criteria to determine that a requisition is ready to be closed and that it does not need to be modified in the future.

The following table details the business-related criteria referenced by the Close Requisitions process and the settings and statuses that must be met to qualify for closure. Each of the criteria discussed must be met for the Close Requisitions process to close a requisition.

The settings and statuses referenced by the Close Requisitions process include a sourcing requirement that requires all lines on a requisition to be accounted for on a purchase order to qualify for closure. Sourcing requirements can also be met if the requisition lines are fulfilled using the inventory demand functionality or a combination of the two sourcing options.

General Criteria	Qualifying Setting or Status
Close Days The Close Days field on the Purchasing Definition - Business Unit Definition page specifies the number of days beyond a requisition last activity date during which a requisition cannot be closed. The value for the Close Days field creates a grace period during which you can make changes to a requisition after the requisition qualifies to be closed, but before the requisition closes. If you leave the Close Days field blank, the system uses zero close days. Note: The Close Days value that you define for the business unit is for purchase order reconciliation and has no relationship to the close days value on the Close Short Run control pages.	The Close Requisitions process verifies that the number of close days defined for the requisition PeopleSoft Purchasing business unit have elapsed. The system adds the value in the Close Days field to the last activity date to determine whether the required number of grace period days have passed. For example, for a Close Requisitions process run date of August 31, 2000, suppose that the last activity date for the requisition is August 25, 2000, and the close days is set to five days. In this example, the process would close the requisition.
Cancel Days The Cancel Days field on the Purchasing Definition - Business Unit Definition page specifies the number of days beyond a requisition's last activity date during which the canceled requisition cannot be closed. The value for the Cancel Days field creates a grace period during which a canceled requisition cannot be closed. If you leave the Cancel Days field blank, the system uses zero cancel days. Cancel days is a business unit attribute; therefore, the system omits the cancel days calculation when the Close Requisitions page specifies a specific requisition ID.	The value for the Cancel Days field works in the same way as the value for the Close Days field, but for canceled requisitions. The Close Requisitions process verifies that the number of cancel days defined for the requisition's PeopleSoft Purchasing business unit has elapsed. The system adds the value for the Cancel Days field to the last activity date to determine whether the required number of grace period days have passed. Note: The Close Requisitions process does not change the line status from Canceled to Complete. However, it does change the header status to Complete. The requisition line status remains Canceled so that you can distinguish canceled lines from closed lines.

Record-Level Criteria	Qualifying Setting/Status
PO Status	The Close Requisitions process verifies that the purchase orders to which the requisition lines are sourced have a Completed status.
Activity Date The system updates this date on the requisition when you save your requisition.	The Close Requisitions process adds criteria, such as close days and cancel days, to the last modified date and time on the requisition Activity Log page. Then the process compares the resulting date to the Close Requisitions process run date (current date) to determine whether it can close the requisition. You can view activity date values by writing a Structure Query Language (SQL) statement against the PS_REQ_HDR record and looking at the ACTIVITY_DATE field.
Distribution Line Status	The Close Requisitions process verifies that the requisition distribution line status is set to X (canceled) or P (processed). A requisition has a status of P after it is sourced to a purchase order or copied to a request for quote.
Entry Event Status	If commitment control is enabled, the Close Requisitions process verifies that you have Entry Event checked for the row.

The Close Requisitions process closes a requisition if any one of the following is true:

• The requisition status is Canceled (PS_REQ_HDR.REQ_STATUS = X), and the last activity date is less than or equal to the current date minus the close days:

  (Last Activity Date) <= (Current Date) – (Close Days)

• The requisition has been sourced to a purchase order (PS_REQ_LN_DISTRIB.DISTRIB_LN_STATUS = P), the purchase order status is Completed, and the last activity date is less than or equal to the current date minus the close days:

  (Last Activity Date) <= (Current Date) – (Close Days)

• The requisition has been sourced to inventory (PS_REQ_LN_DISTRIB.DISTRIB_LN_STATUS = P), and the last activity date is less than or equal to the current date minus the close days:

  (Last Activity Date) <= (Current Date) – (Close Days)

You can view requisition header information (PS_REQ_HDR) and requisition distribution information (PS_REQ_LN_DISTRIB) by accessing the requisition online or by writing an SQL statement against the mentioned tables as necessary.