E1: 41: Inventory Purge Programs (R4101P / R4102P) (Doc ID 1322000.1)

Last updated on OCTOBER 10, 2023

Applies to:

Purpose

Overview

There are 2 types of Purge programs

• UBE
• Table Conversion

For UBE, in releases XE to 8.10, Purge programs should be run locally, on a full client.

For Table Conversions, in releases beginning with JD Edwards EnterpriseOne 8.11SP1, any Table Conversion Purge can be run on the server as long as the processing options are not set to archive.

Full Client:

• Clicking SELECT will display a screen with 4 options, including properties check box. Once properties box is checked and submitted, a new window with following tabs will appear.
• Select Environment: Specify the environment if the data is archived in a table. Make sure the environment is different than the user environment.
• Data Selection: perform your data selection here.
• Remaining 3 tabs are Table Options, Logging Options and Debug Logging

HTML Client:

• User will be able to perform data selection as they do on a regular UBE

Note 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.

Performing these table conversions in a test environment is always recommended prior to running in production.

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.

Scope

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.