This chapter contains these topics:
Section 45.1, "Purging Data for ECS Sales Order Management,"
Section 45.2, "Running General Purges for ECS Sales Order Management,"
From ECS Sales Order Management (G4910), enter 27
From ECS Sales Order Advanced and Technical Ops (G491031), choose Data File Purges
From Data File Purges (G42312), choose an option
When data becomes obsolete or you need more disk space, you can use purge programs to remove data from files.
Purging data consists of:
Specifying the information to delete
Running the purge program
Running the file reorganization program to rebuild the file structure
Caution:
You must know the proper procedures and consequences of purging data to avoid serious damage to your 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 two types of purges:
Run general purges
Run special purges
General purges are DREAM Writer versions of the JD Edwards World general purge program that removes data from a specified file. You run these purges when you want to remove a large amount of data.
JD Edwards World provides special purges for removing data from files where the selection criteria needs to be more specific. Special purges are DREAM Writer programs that have predefined criteria that the system checks before removing any data so you avoid removing associated data located in other files.
You run these general and special purge programs in the ECS Sales Order Management system only if you want to manually purge the associated tables. You can instruct the system to automatically purge most of these tables during end of day processing. You can set the processing options for the Update Customer Sales program to automatically purge the following tables:
Sales Order Header (F4201)
Sales Order Detail (F4211)
Sales Order Detail - Tag History (F49219)
Text Detail Lines (F4314)
Price Adjustment History (F4074)
General purges for the ECS Sales Order Management system include:
Sales Order Detail purge
Sales Order Detail History purge
Sales Order Ledger purge
General purges are DREAM Writer versions of the JD Edwards World general purge program that removes data from a specified file. You run general purges when you want to remove a large amount of data.
You can create DREAM Writer versions of the general purge program to purge data from any JD Edwards World file. However, JD Edwards World recommends that you do not use general purges for files that have their own special purge programs. General purges are not designed for files that have associated data in other files. Running a general purge for such files could cause you to lose data.
The general purges remove records with a next status of 999, or closed, from the specified file.
Before creating a new DREAM Writer version to purge a file, verify that a special purge program does not exist for that file. The ledger and balances files require special processing to select records. Those that can be purged have their own specific purge programs.
To create a new DREAM Writer version to purge a file, access the Versions List for P00PURGE. In this example, a P00PURGE version is being created for the Item Location file (F41021) from an existing version that purges the Item History file (F4115).
To Create a New DREAM Writer Version for a Purge
On Versions List.
Enter a 3 next to the DEMO version of Item History.
Figure 45-2 DREAM Writer Version Copy screen
Enter a version title that identifies the new purge being created.
Complete the following fields to reflect the new file:
Based on File
Format Name
Set Processing Options as desired.
Review the Data Selection.
Note that the existing selection criteria from the Item History has been retained. These fields can be removed by entering N in the Include in Selection field and then pressing F5 to update.
Press F16 to Display All Data Fields of the Based on File field you selected to create your data selection. Enter a Y against the specific fields you want to include.
Figure 45-5 Data Selection (All Data Fields) screen
As with data selection, the sequence fields from the Item History version is retained. Remove these in a similar manner and then press F16 to Display All Data Fields of the Based on File field you selected to create your data sequencing criteria.
Enter the numerical sequence for the fields of your version. After you press Enter, your version is created and you are returned to the versions list display.
Topic | Description |
---|---|
Sales Order Detail purge | You specify whether the system writes closed order lines to the Sales Order Detail History file and leaves only canceled order lines in the Sales Order Detail file when you run the Update Customer Sales program.
You use the Sales Order Detail purge to remove records from the Sales Order Detail file. Optionally, you can move the records from the Sales Order Detail file to the Sales Order Detail History file. See Section 45.3.5, "Running Move Sales Order Detail to History (ECS)." |
JD Edwards World provides special purges for removing data from files where the selection criteria needs to be more specific. Special purges are DREAM Writer 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.
Running special purges includes:
Running the Sales Order Header purge
Running the Extended Text purge
Running the Batch Order Files purge
Running Move Sales Order Detail to History
You use the Sales Order Header purge to purge sales order header records from the Sales Order Header file. The system purges records from the Sales Order Header file only if no open detail lines with a matching order type and order number combination exist in the Sales Order Detail file. In addition to purging records, you can optionally move information to the Sales Order Header History file (F42019). You specify in the processing options whether you want to move information. Since this program only selects header records without matching detail records, it is advisable to run it immediately after the corresponding detail purge program.
This Sales Order Text Line program (P42960) is not exactly a purge program in that is does not delete any records. Specifically, the program reads through the Sales Order Detail file (F4211) looking for Text lines (Line type is equal to 'T') that do not have any associated non-text lines. Each record found that matches this criteria is set to closed by having its next status set to 999. These detail records can then be purged by either the general or special Sales Order Detail purges.
You use the Extended Text purge to delete specific information from the Text Detail Lines file (F4314).
This purge checks the Sales Order Detail and the Purchase Order Detail files for open detail lines with matching order type and order number combinations. One of the following occurs:
If the system does not find matching records, it deletes the extended text from the Text Detail Lines file.
If the system finds matching records, it deletes the extended text from the Text Detail Lines file only if the matching detail files have a status of 999.
You can delete processed sales orders from the batch receiver files by using the Batch Order Files purge. The system selects only records with Y in the Processed (Y/N) field of the batch receiver files.
The following files are purged by this program:
Batch Receiver File - Order Headings (F4001Z)
Batch Receiver File - Order Details (F4011Z)
This purge does not remove records from the Destination Quantity file (F4012Z) or the Unmappable Data file (F4014Z). Use the general purge program to remove data from these files.
You run the Move Sales Order Detail to History program to purge detail lines with a status of 999 from the Sales Order Detail file (F4211) and move them to the Sales Order Detail History file (F42119).
You can run this program when you run the Update Customer Sales program.