Purge History Concurrent Program (PURGE_WMS) Did Not Purge LPN Records (Doc ID 1507409.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

Purge program is not purging all the records. Program completed successfully without purging any records
Log Message
 +---------------------------------------------------------------------------+
Warehouse Management: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
PURGE_WMS module: Purge WMS History Tables
+---------------------------------------------------------------------------+
Current system time is 16-OCT-2012 12:46:26
+---------------------------------------------------------------------------+
**Starts**16-OCT-2012 12:46:26
**Ends**16-OCT-2012 12:56:52
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
  ********* New Session:37332011****16-OCT-12:01.14.17 **********
[16-OCT-12 13:14:19] Purge_WMS: Fecthed LPNs based on date and context first=last=
[16-OCT-12 13:14:19] WMS_PURGE_PVT.PURGE_WMS: Total number of rows deleted
from WMS_PACKAGING_HIST: 0
.
[16-OCT-12 13:14:19] WMS_PURGE_PVT.PURGE_WMS: Total number of rows deleted
from WMS_LPN_HISTORIES: 0
.
[16-OCT-12 13:14:19] WMS_PURGE_PVT.PURGE_WMS: Total number of rows deleted
from WMS_LPN_CONTENTS: 0
.
[16-OCT-12 13:14:19] WMS_PURGE_PVT.PURGE_WMS: Total number of rows deleted
from WMS_LICENSE_PLATE_NUMBERS: 0
.
[16-OCT-12 13:14:19] WMS_PURGE_PVT.PURGE_WMS: Total number of rows deleted
from WMS_EPC: 0
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
Current system time is 16-OCT-12 13:14:19
+---------------------------------------------------------------------------+

Cause

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