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.
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 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!