Understanding the Production Archive and Purge Process

PeopleSoft Manufacturing enables you to archive or purge production data contained in production tables to reduce storage needs and increase performance. You can move the production data into archive tables.

Before you archive production data, keep these points in mind:

  • You can archive data for production IDs and production schedules.

  • You can archive production data for configured orders (production IDs).

    However, configured orders must meet these criteria:

    • All lines on the related sales order must have a status of Closed or Canceled.

    • All lines on the direct production order must have a status of Closed or Canceled.

  • You can archive data for teardown and rework production IDs.

  • All manufacturing costing must be completed before you can archive production data.

    All components must be consumed or deleted before archiving or purging can occur.

  • All manufacturing accounting lines must be posted to the general ledger before you can archive production data.

    If this posting process is not completed, the production orders will be disqualified during the qualification process.

  • You cannot archive serial genealogy production data.

  • You cannot purge production IDs that have subcontracted purchase orders.

  • You may break certain relationships, such as production ID splits and configured production orders.

Page Name

Definition Name

Usage

Archive Production Data Page

RUN_SF_PURGE

Select production data to be archived or purged.

Archive Parameters Page

RUN_SF_PURGE_PARM

Enter selection criteria for the production data to be archived or purged.

See the product documentation for PeopleTools: Application Designer Developer's Guide

Once you have completed production, determine if you want to move or purge production data.

Use the Archive Production Data page (RUN_SF_PURGE) to select production data to be archived or purged.

Navigation:

Production Control > Close and Analyze Production > Archive Production Data > Archive Production Data

This example illustrates the fields and controls on the Archive Production Data page. You can find definitions for the fields and controls later on this page.

Archive Production Data page

Purge Process Option

Select one of these options:

  • Archive/Purge: Move selected data into ARCH (archive) tables and also purge the data from the production tables.

  • Purge: Delete selected data from the production tables.

Use the Archive Parameters page (RUN_SF_PURGE_PARM) to enter selection criteria for the production data to be archived or purged.

Navigation:

Production Control > Close and Analyze Production > Archive Production Data > Archive Parameters

Field or Control

Description

Date, Select Production IDs, and Select Production Schedules

Select values based on All or a Range for production dates, production IDs, production areas, or item IDs.

Note: Using the Date option enables you to select data based on the production due date.

Warning! The purging function is powerful. Improper use might result in the unintentional loss of data. We recommend that you use the purging process only after you have been properly trained to use it.