Purging Data

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

Understanding Data Purges

After data becomes obsolete or you need more disk space, you can use purge programs to remove data from files. To create a configured purge, you can change the data selections to meet the needs. For example, you could specify a range of fiscal years rather than all dates so that the system would purge only records that fall within that date range.

Purging data consists of:

• Determining the data that you want to purge.

• Running the purge program.

• Running the file reorganization program to rebuild file structure.

  Important! You must know the proper procedures and consequences of purging data to avoid serious damage to the system and data.

Purging Data

This section provides an overview of purge programs, lists prerequisites, and discusses how to:

• Run the item master purge.

• Run the item balance purge.

• Set processing options for Item Balance Purge (R4102P).

Understanding Purge Programs

Every JD Edwards EnterpriseOne Distribution system is shipped with special purge programs. In the JD Edwards EnterpriseOne Inventory Management system, the special purge programs include:

• Item Master Purge (F4101) (R4101P), which removes data from F4101.

• Item Balance Purge (F4102) (R4102P), which removes data from F4102.

Both special purges enable you to provide more specific information. Special purges have built-in criteria that the system checks before removing any data. For example, you might want to purge an Item Master record that has an associated record in the F41021 table. The built-in selection criterion prevents the system from purging the Item Location File record.

You can set processing options to save purged records. These processing options are helpful if you need to recover data that was inadvertently purged.

Prerequisites

Before you complete the tasks in this section, you must:

• Save copies of the files that will be affected

• Verify that no users are working with the data that you want to purge.

Running the Item Master Purge

Select Global Updates & Purges (G41311), Item Master Purge (F4101).

The Item Master Purge (R4101P) program enables you to select and purge specific information from the F4101 table. Before purging the records that you specify from the Item Master table, the system verifies that the records are not associated with other tables. The system does not purge any item information from these tables:

• F41021

• F4102

• F4105

• F4108

• F3002

• F3003

Running the Item Balance Purge

Select Global Updates & Purges (G41311), Item Balance Purge (F4102).

The Item Balance Purge (F4102) program enables you to select and purge records that you specify from the F4102 table. Before purging the specified records from the Item Branch File table, the system verifies the records using this criteria. The system does not purge the records if:

• Work orders exist in the Work Order Master File (F4801).

• A parts list exists in the Work Order Parts List (F3111).

• A bill of material exists in the Bill of Material Master File (F3002).

• Any secondary locations exist in the Item Location File (F41021).

• Information is in any of these fields for the item location record:

  • On-hand

  • Hard Commitments

  • Soft Commitments

  • Back Order Quantity

  • On Order Quantity

  • Quantity Outbound (EDI)

  • Quantity Inbound (EDI)

    The system also checks all quantity fields for primary and secondary locations.

After the system determines which Item Balance records are to be purged, the system:

• Verifies the records in the Item Branch File table.

• Verifies that all records in the F41021 table with the same item and branch have zero quantities.

• Checks the Bill of Material Master File, Work Order Parts List, and the Work Order Master File tables.

  If it does not use this item and business unit combination in any of these tables, the system continues.

• Starts the purge process.

• Purges the Item Branch File record first.

  If the cost level for this item is 2, the system purges the cost records for this item and branch.

• Purges the Unit of Measure Standard Conversion records for this item and branch.

• Purges the Item Location File records.

  If the cost level for this item is 3, the system purges the cost records for this item, branch, location, and lot.

If you set the processing option to delete all item branch information, the system:

• Checks the Item Branch File table.

• Starts the purge process.

• Verifies the F41021 table to ensure that records with the same item and branch have zero quantities and are not primary bins.

  If these conditions exist, the system purges these records.

• Purges the cost records for item, branch, location, and lot if the cost level for this item is 3.

If you set the processing option to save purged records, purges that are performed on the same table and on the same day are added to the existing library and table.

Setting Processing Options for Item Balance Purge (R4102P)

Processing options enable you to specify the default processing for programs and reports.

Process