Skip navigation

Is your system performance slow? When launching a program, is your data returned quickly or, do you sit and wait for an inquiry screen to return information? Does it take hours to run a batch job such as Order Processing (P31410) to attach a work

order routing and parts list?

 

Should the above be true for your system, it is time to purge data.

 

Purging data from your files is the process of freeing up space in your system. When data is not purged, your database can grow so large that performance begins to deteriorate. Oracle/JDE customers have been using Manufacturing and Distribution

(M&D) software since the early 1990's. Can you believe that 27 years have already past and that in many cases, your data still contains records from the beginning of time.

 

Purging data does not necessarily mean that you are deleting data. Oracle/JDE provides programs to archive your data. Once the data is archived, it can be merged back to your existing data files if warranted. Or, better yet, a separate environment can

be created to view the archived data if needed.

 

There are several areas to take into account when purging your data. For example, what is your companies data retention policy? Are you to keep 10 years worth or data or 20+ years of data? Many companies are also SOX [Sarbanes-Oxley Act] compliant.

You will need to determine how many years worth of data SOX specifies.

 

The purge process can be based on the age of the data or the type of data which is discussed in several documents explaining how to archive your data.

 

When Should You Purge/Archive Manufacturing & Distribution files?

 

Customers are encouraged to review the information included in P00PURGE-Generic Purge Program (Doc ID 626668.1) before purging data. Running POOPURGE creates a special purge library name where your purged data is written to.

 

Launching POOPURGE over Distribution data should include the detail file along with the associated header file. An example of this is purchase orders. Purging both the Purchase Order Detail File (F4301) and the Purchase Order Header File (F4301) keeps your purchasing files in sync with one another.

 

Manufacturing has its own purge program called Purge Work Orders (P4801P) which is discussed in Purge Work Orders (P4801P) (Doc ID 1945189.1).

 

Another document that may be of interest is  World Purge and Database FAQs (Doc ID 1169966.1). Many documents exist in Knowledge Management. Using the search word of Purge, will return the documents available for each module.

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.