EBS Upload Local Forecast Workflow Failure: Database internal error: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-20007: Error: msd_dem_upload_forecast.upload_forecast (Doc ID 733624.1)

Last updated on APRIL 17, 2015

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to runs the EBS Upload Local Forecast workflow, it fails at the step of PopulateDenormTable. The view BIEO_LOCAL_FCST does get created, but table msd_dp_scn_entries_denorm was not populated. 

Logs show the following error:

process initiator name : dm

Description : Process ID: 2018
Schema ID: 634
Schema name: 'EBS Upload Local Forecast'
Step ID: 'PopulateDenormTable'
Step name: 'PopulateDenormTable'

Error description 'Database internal error: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-20007: Error: msd_dem_upload_forecast.upload_forecast - Forecast has not yet been exported'
Source : dm

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