Order Purge
The Order Purge Selection and Order Purge programs select and purge orders based on criteria you specify. Purging old data creates space in your database and can improve performance of transactions and maintenance.
Purge Restrictions
Orders can only be purged if they meet the following conditions:
- No open demand exists for the order including open work orders, open invoices, open returns, open requisitions.
Selection Process
Use the Order Purge Selection program to determine which orders you want to purge. The selection criteria available are:
Archiving
Oracle recommends that you archive the selected orders before running the Order Purge program. The easiest method for archiving is to run a SQL statement to move the selected orders to mirrored purge tables.
Purge Selection Table
Orders selected for purging are stored in the SO_PURGE_ORDERS table. The table consists of the following columns:
- HEADER_ID (NUMBER PRIMARY KEY, NOT NULL)
- CREATION_DATE (DATE, NOT NULL)
- CREATED_BY (NUMBER, NOT NULL)
- LAST_UPDATE_DATE (DATE, NOT NULL)
- LAST_UPDATED_BY (NUMBER, NOT NULL)
- LAST_UPDATE_LOGIN (NUMBER, NULL)
- REQUEST_ID (NUMBER, NULL)
- PROGRAM_ID (NUMBER, NULL)
- PROGRAM_APPLICATION_ID (NUMBER, NULL)
Purged Tables
The Order Purge program purges the order information from the following tables:
Submission
Your system administrator must add the order purge programs to your menu. Using the Define Report Groups form you can add the order purge programs to an existing report group, or you can create a new report group with a new menu entry.
To submit the program, navigate to the window to which you assigned the purge programs and enter Order Purge Selection or Order Purge in the Name field.
Parameters
Order Purge Selection
Enter any combination of the following optional parameters to select the orders to purge.
Order Category
Enter an order category to which to restrict the purge.
Order Type
Enter an order type to which to restrict the purge.
Customer
Enter a customer to which to restrict the purge.
Order Number From
Enter the beginning order number to restrict the purge to a range of orders.
To
Enter the ending order number to restrict the purge to a range of orders.
Order Date From
Enter the beginning order date to restrict the purge to a range of order dates.
To
Enter the ending order date to restrict the purge to a range of order dates.
Creation Date From
Enter the beginning creation date to restrict the purge to a range of creation dates.
To
Enter the ending creation date to restrict the purge to a range of creation dates.
Order Purge
Enter the following required parameter to submit the orders to be purged.
Orders per commit
Enter the number of orders to purge per commit. Oracle suggests that you limit the number of orders to purge to batches of 100 or fewer. If Oracle Order Entry/Shipping encounters a locked file during the purge, it skips the entire batch or orders. Smaller batches also yield better performance.