Executing the Purge Batch (PURGE_RWMS_TABLES.SH) Deletes the Default Entry in the ROUTE_DEST Table (Doc ID 1967806.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Retail Warehouse Management System - Version 13.2.4 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Warehouse Management System (RWMS) 13.2.x, the entry in the ROUTE_DEST table with the default date is getting purged after running the purge batch.


Steps to Reproduce:

  1. Create an entry in the table ROUTE_DEST with ROUTE_DEST.SHIP_DATE as 01/JAN/1900. 
  2. Execute the PURGE_RWMS_TABLES.sh.
  3. Check the data in the ROUTE_DEST table.  Note that the ROUTE_DEST.SHIP_DATE as 01/JAN/1900 has been purged. 

 

Changes

 

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