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

Last updated on APRIL 26, 2017

Applies to:

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

Symptoms

 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

 

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