My Oracle Support Banner

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.


On : 7.3.0 version, LoadData

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

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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