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

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
Purge History Concurrent Program (PURGE_WMS ) Did Not Purge LPN Records

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms