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