MSDDEMSDP module: Sales Data Pre Processor fails with 'ORA-00942: table or view does not exist' - No Forecast Generated In SPP (Doc ID 1901649.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : 12.1.3.9 version, Memory Based Planner 

Users are on 12.1.3 and have applied VCP 12.1.3.9.1 <Patch 17350769> - no one offs for snapshot or MBP at this time.  Users are trying to generate an inline forecast with Service Parts Planning - SPP - However no forecast is being generated in SPP

Demantra is not being used at this time

Users are loading Demhistory.dat file using the navigation -
Service Supply Chain Planner > Collections > Legacy Systems> Shipment History – self service
the load is failing with Sales Data Pre Processor error.

MSDDEMSDP module: Sales Data Pre Processor

**Starts**17-JUN-2014 13:26:50
**Ends**17-JUN-2014 13:26:50
ORA-00942: table or view does not exist

  Legacy Instance ID : 3026
 
Pushing time data for Legacy Instance
Push Time Data - Actions
------------------------------

Deleting time data from source msd_dem_dates
Exception: msd_dem_push_setup_parameters.push_time_data - 17-JUN-14
ORA-00942: table or view does not exist
Fetching value for parameter - MSD_DEM_MASTER_ORG from msd_dem_legacy_setup_params
Fetching value for parameter - MSD_DEM_CATEGORY_SET_NAME from msd_dem_legacy_setup_params
Deleting records for profiles MSD_DEM_MASTER_ORG and MSD_DEM_CATEGORY_SET_NAME from msd_dem_setup_parameters in the destination instance
Inserting profile MSD_DEM_MASTER_ORG into msd_dem_setup_parameters
Inserting profile MSD_DEM_CATEGORY_SET_NAME into msd_dem_setup_parameters
Push Legacy Setup Parameters Failed


Even though this errors out the data is still getting into table MSD.t_src_sales_tmpl. However it's not making it into the view msd_shipment_history_v

EXPECTED BEHAVIOR
-----------------------
Data should be available to the view so that SPP can use it to generate inline forecast

The issue can be reproduced at will with the following steps:
1. Users are loading Demhistory.dat file using navigation:
   Service Supply Chain Planner > Collections > Legacy Systems> Shipment History – self service

2. The load is failing with Sales Data Pre Processor error



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