Purging Data

This chapter provides an overview of data purge programs and discusses how to purge data.

Understanding Data Purge Programs

When data becomes obsolete or you need more disk space, you can use purge programs to remove data from files.

The system provides purges for removing data from files where the selection criteria needs to be specific. Purges are programs that have predefined criteria that the system checks before removing any data so that you avoid removing associated data that is located in other files.

Important! You must know the proper procedures and consequences of purging data to avoid serious damage to the system and data. Purging data is typically performed by a system administrator or operations personnel. Only those employees who understand the purging process and its results should be allowed access to this procedure.

You can run these purge programs in JD Edwards EnterpriseOne Procurement:

Detail (F4311) Purge (R4311P).
Receiver (F43121) Purge (R43121P).
Ledger (F43199) Purge (R43199P).
F4301 Purchase Order Header Purge (R4301P).
Close Text Lines (R43960).
F43001 Purge Transaction Records (R43001P).

This program purges the Procurement Self-Service Transaction Log table (F43001).
Purge Purchase Order Dispatch (R4333WFP).

This program purges the Purchase Order Dispatch Work File table (F4333WF).

Considerations

When you run the F4301 Purchase Order Header Purge program (R4301P), the system purges records only if no active detail lines exist. Therefore, before you run the F4301 Purchase Order Header Purge program, you should run the Detail F4311 Purge program (R4311P).

The R4301P purges the Purchase Order Detail Non-Billable (F4317) and Purchase Order Receiver Non-Billable (F43127) tables and also purges the values in the supplier classification code fields.

Unlike the other purge programs, the Close Text Lines program (R43960) does not delete data. The program moves text lines to a status of 999 for an order that is closed.

To run the Close Text Lines program, you submit a batch job using the Available Versions form. You run the Close Text Lines program the same way that you run reports or any other type of batch job.

Prerequisites

Before you purge data:

Create a purge environment, which enables you to save purged records and prevents the records from being overwritten when you upgrade the software.
Back up the files that will be affected.
Determine the data that you want to purge.
Verify that no users are working with the data that you want to purge.

Purging Data

This section discusses how to:

Purge data.
Run the F43001 Purge Transaction Records program (R43001P).
Run the Purge Purchase Order Dispatch program (R4333WFP).

Forms Used to Purge Data

Form Name	FormID	Navigation	Usage
Available Versions	W98305WA	Data File Purges (G43A311), any option	Purge data.
Table Conversion Prompting	W98305WO	Select a version on the Available Versions form, and then click the Select button.	Specify purge settings.

Purging Data

Access the Available Versions form.

Use this procedure to run any of the purge programs in the JD Edwards EnterpriseOne Procurement system (with the exception of the CloseText Lines purge).

To purge data:

Select a version.
On Table Conversion Prompting, select the Properties option and click Submit.
On the properties window, select the Select Environments tab.
Select the From and To environments, which enable you to specify the environment from which to purge data and the environment in which to store purged data.
Select the Data Selection tab and specify the information to purge.

The system automatically displays processing options for the purge program.
Click OK.
Complete the processing options according to these guidelines:
- For the first processing option, enter 1 to save purged records.
  
  You cannot save purged records unless you have created a purge environment. If you leave this processing option blank, the system deletes all purged records.
- For the second processing option, enter a new name for the environment that stores purged records.
  
  By renaming the environment before you run a purge program, you can store the records from each purge separately. Otherwise, the system overwrites the data each time that you run the purge program. Before completing this processing option, ensure that you have specified that you want the system to save purged records. After completing this processing option, you must complete the third processing option, which enables you to enter the data source name.
- For the third processing option, enter the name of the data source for the purged records.
  
  Before completing this processing option, ensure that you have specified that you want the system to save purged records and that you have entered a new environment name.
To run the purge program, click OK.

To exit without running the purge program, click Cancel.

Running the F43001 Purge Transaction Records Program (R43001P)

Select System Administration Tools (GH9011), Batch Versions.

Alternatively, enter BV in the Fast Path field.

Running the Purge Purchase Order Dispatch Program (R4333WFP)

Select System Administration Tools (GH9011), Batch Versions.

Alternatively, enter BV in the Fast Path field.