Purging Purchasing Staging Tables

This section provides an overview of the Purge Stage Tables process and discusses how to run the Purge Stage Table Application Engine process.

Page Name

Definition Name

Usage

Purge Stage Tables Page

RUN_PO_POSTGPRG

Enter the selection criteria for the Purge Stage Tables process and run the process.

The Purge Stage Tables process (PO_POSTGPRG) purges entries on the PeopleSoft Purchasing staging tables. Only rows in C (completed), E (error), or X (ready to purge) status are eligible for purging.

For rows in an E (error) status, the Purge Stage Tables process only purges those that it can reset. This includes staged rows from requisitions or cart (par) replenishment, PeopleSoft Purchasing contract releases, PeopleSoft Supply Planning, and PeopleSoft Production Management. It cannot purge staged rows in error from RFQs.

The tables purged by the Purge Stage Tables process are:

  • PO_ITM_STG

  • PO_HDR_STG

  • PO_DISTRIB_STG

  • PO_ITM_STG_UD

  • PO_ITM_STG_VND

  • PO_VAL_ADJ_STG

  • PO_SRC_TMP_BU

  • PO_SRC_TMP_FRT

  • PO_SRC_TMP_HDR

  • PO_SRC_TMP_IVND

  • PO_SRC_TMP_TAX

  • PO_SRC_TMP_VNDR

PeopleSoft recommends that you run this process at least weekly. In very busy installations, you should consider running the Purge Stage Tables process daily. If you do not run the Purge Stage Tables process regularly, the staging tables retain old data, which negatively affects performance of processes that act on the tables.

Before purging error rows, the Purge Stage Tables process removes the in process status on the requisition line, and sets the source status on the requisition line to A (available).

Requisitions in error status are identifies as in process, while they are in the staging tables. In process requisitions cannot be updated. Running the Purge Stage Tables process on error rows frees up requisitions for error correction.

If you run purge on a requisition in Error status on the Sourcing Workbench - Sourcing Details page, it frees the requisition, and sets the stage status on the stage tables to X, so it can be purged in this process. If you recycle an error, it has no effect on the requisition, but it sets the stage status on the stage tables to R, so the row can be picked up and processed again.

After you run the Purge Stage Tables process, rows in error status that have requisitions associated with them have these results:

  • If the requisition was staged by the AutoSelect Requisitions process, the open quantity is reset to the requisition quantity.

  • The in process setting is cleared from the requisition.

  • Source status on the requisition line is returned to A.

  • For PeopleSoft Purchasing contracts, it sets the release status back to O (open) so the contract can be rereleased.

  • For PeopleSoft Supply Planning, it sets the subPO status to 20, so it can be reselected by the PO Stage Load process.

Use the Purge Stage Tables page (RUN_PO_POSTGPRG) to enter the selection criteria for the Purge Stage Tables process and run the process.

Navigation:

Purchasing > Purchase Orders > Stage/Source Requests > Purge Stage Tables

Field or Control

Description

Purge Staged Rows in Error

Select to purge rows in error whose stage status is E (error). This also releases associated requisitions.

Purge Completed Stage Rows

Select to purge completed stage rows and rows ready for purge whose stage status is C (completed), W (warning), or X (ready to purge).

PO Stage Record Type (purchase order stage record type)

Used in combination with purchase order build stage ID to limit the purging of the stage tables to rows originating from a particular staged entry.

PO Stage ID (purchase order stage ID)

Used in combination with the PO Stage Record Type field to limit the purging of the stage tables to rows originating from a particular staged entry.