EBS Upload Local Forecast Workflow Fails at the step 'Populatedenormtable' ORA-20010:Error: msd_dem_upload_forecast.upload_forecast -Item or Product Family lev (Doc ID 1275609.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2013***

Symptoms


PROBLEM
-------------
In Demantra after the forecast is generated,  the EBS Upload Local Forecast workflow has been submitted. This workflow always fails at the Step 'PopulateDenormTable'.

Error Message:
Error description ’’Database internal error:ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast_with_app_id - ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-20010: Error: msd_dem_upload_forecast.upload_forecast - Item or Product Family lev’’

STEPS
--------
Run EBS Upload Local Forecast Workflow
It fails

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