My Oracle Support Banner

Service Parts Planning MSDDEMCSH module: Collect Shipment History Errors ORA-00936 Missing Expression (Doc ID 1501029.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle Service Parts Planning - Version 12.1.3 and later
Information in this document applies to any platform.


 On 12.1.3 - Service Parts Planning in Test:

Users are not using Demantra but they are running ASCP data collections between a source EBS/ERP instance with destination instance for ASCP/SPP. Users are running MSDDEMCSH module: Collect Shipment History

But it errors with the following:

Date From (DD/MM/RRRR) - 01/01/1000
Date To (DD/MM/RRRR) - 31/12/4000
Deleting data from sales staging table - MSD.T_SRC_SALES_TMPL
Fetched the schema name as : MSD
Exception(1): msd_dem_collect_history_data.collect_series_data - 11-OCT-2012 13:08:03
ORA-00936: missing expression
Error(17): msd_dem_collect_history_data.collect_history_data - 11-OCT-2012 13:08:03
Error while collecting Shipment History - Requested Items - Shipped 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.