My Oracle Support Banner

Warehouse Management: How To Purge License Plate Numbers, Tasks, Exceptions, Waves, Labels, Device History Tables (Doc ID 2887152.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Warehouse Management - Version 12.2 and later
Information in this document applies to any platform.

Goal

WMS Purge History concurrent program can be used to purge data from various WMS tables at timely intervals to avoid performance issues and keep them from growing too huge.

This document explains what types of entities in Warehouse Management can be purged. It also clarifies the filters used for the purge what data would be selected for the purge when the program is run for a specific set of parameters.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Concurrent Program 
 2. Purge Types
 3. Validations on "Eligible data" for purge
 4. FAQ
 1, How to purge WMS Exceptions ?
 2. How frequently should this program be used ?
 3. What is the "Purge Age" parameter ?
 4. PURGE_WMS Is Not Purging Data In WMS_LICENSE_PLATE_NUMBERS And WMS_LPN_CONTENTS ?
 5. How to identify what data was purged by the purge program ?
 6. Purge program does not purge any data ?
 7. How is wms_lpn_process_temp purged ?
 8. How to purge WMS_RULE_TRACE_HEADERS and WMS_RULE_TRACE_LINES ?
 9. Does the program archive data automatically ?
 10.  Purge type "Task" not available in the List of values ?
 11. How is the "Purge Age" parameter used ?
References

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