Collect Shipment and Booking History: Warning: can not purge old shipment/booking history data (Doc ID 1646318.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 12.2.3 [Release 7.3.0 to 12.2]
Information in this document applies to any platform.

Goal

 Customer is running Collect Shipment and Booking History and gets the following error in the logs

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
 Collect History Data - Actions
--------------------------------
 
Date From (DD/MM/RRRR) - 01/03/2004
Date To (DD/MM/RRRR)   - 31/03/2004
Deleting data from sales staging table - MSDEM.T_SRC_SALES_TMPL
Fetched the schema name as : MSDEM
Begin Delete data from ERR table - MSDEM.T_SRC_SALES_TMPL_err
Analyzing Table - MSDEM.T_SRC_SALES_TMPL
For the selected series, the old data will be purged from '01-MAR-04' to '29-MAR-04'
Warning: can not purge old shipment/booking history data.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Solution

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