Demantra Request - Collect Shipment or Booking History - Failed With Error Ora-30926 (Doc ID 1156413.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms


On : 7.3.0 version, LoadData

When running Demantra Collect Shipment and Booking History (MSDDEMCHD module),
the following error occurs.

ERROR
-----------------------
ORA-30926: unable to get a stable set of rows in the source tables


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run ASCP Standard Collections.
Collection complete successfully.
2) Run demantra Shipment and Booking History.
Collection error out with the following error message in the log file:

Date From (DD/MM/RRRR) - 01/01/1000
Date To (DD/MM/RRRR) - 31/12/4000
Deleting data from sales staging table - DM.T_SRC_SALES_TMPL
Begin Delete data from ERR table - DM.T_SRC_SALES_TMPL_err
Exception(1): msd_dem_collect_history_data.collect_series_data - 20-JUL-2010 00:27:42
ORA-30926: unable to get a stable set of rows in the source tables
Error(12): msd_dem_collect_history_data.collect_history_data - 20-JUL-2010 00:27:42
Error while collecting Booking History - Booked Items - Requested Date

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