Archiving and Purging Production Data

This chapter provides overviews of the production archive and purge process (SF_PURGE) and the ramifications of archiving and purging production data and discusses how to:

Enter parameters to archive or purge production data.
Select archive parameters.

Understanding the Production Archive and Purge Process

PeopleSoft Enterprise 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.

Archiving and Purging Production Data

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

Pages Used to Archive and Purge Production Data

Page Name	Object Name	Navigation	Usage
Archive Production Data	RUN_SF_PURGE	Production Control, Close and Analyze Production, Archive Production Data, Archive Production Data	Select production data to be archived or purged.
Archive Parameters	RUN_SF_PURGE_PARM	Production Control, Close and Analyze Production, Archive Production Data, Archive Parameters	Enter selection criteria for the production data to be archived or purged.

Entering Parameters to Archive or Purge Production Data

Access the 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.

Selecting Archive Parameters

Access the Archive Parameters page.

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.

Understanding the Ramifications of Archiving and Purging Production Data

Keep these points in mind when you determine which production data you want to archive or purge:

For production ID splits, if you purge this data, you won't be able to see the split history.
For configured production IDs, when a configured production order is purged, you won't be able to access the Production ID link from the Direct Production Order inquiry page.

This link enables you to access the Production ID Maintenance component. Therefore, you won't be able to view any transaction history associated with this configured order.
For accounting line drilldowns, you must make sure that the accounting lines are posted to the journal entry before purging this data.

Once you have purged the production data, you won't be able to see the accounting line drilldowns (Cost Management Line Drill Down page).