Purging Data

This chapter provides an overview of data purge programs, lists prerequisites, 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. It is important that only those employees who understand the purging process and its results are 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).

Considerations

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

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, you must:

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.

Forms Used to Purge Data

Form Name	FormID	Navigation	Usage
Available Versions	W98305WA	Data File Purges (G43A311), any option	Run purge programs.
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:

On Available Versions, 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 to purge data from 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.