EBS Upload Local Forecast workflow does not publish forecast To Ascp after rebuilding model ORA-20015 ORA-06512 (Doc ID 789511.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 11.5.10 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Oct -2014***

Symptoms

On EBS-11.5.10.2 integrated with 7.2.0.2 in Production:
When attempting to upload the forecast to ASCP,

-- The BIEO_LOCAL_FCST table is populated.
-- The MSD_DP_SCN_ENTRIES_DENORM table is empty.
-- The item and organization levels have not been renamed.
-- The data model was rebuilt.

The following error is seen in the collaborator.log

ERROR
2009-02-25 11:27:54,331 [WFProcess_1] FATAL workflow.general: appserver.workflow.general
java.sql.SQLException: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-20010:
Error: msd_dem_upload_forecast.upload_forecast - Item or Product Family level is required for upload
ORA-06512: at "APPS.MSD_DEM_UPLOAD_FORECAST", line 1190
ORA-06512: at line 1

STEPS
The issue can be reproduced at will with the following steps:
1. Run the "EBS Upload Local Forecast" workflow
2. See that the workflow errors out at the "PopulateDenormTable" Step
3. The following error is seen in the collaborator.log

2009-02-25 11:27:54,331 [WFProcess_1] FATAL workflow.general: appserver.workflow.general
java.sql.SQLException: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-20010:
Error: msd_dem_upload_forecast.upload_forecast - Item or Product Family level is required for upload
ORA-06512: at "APPS.MSD_DEM_UPLOAD_FORECAST", line 1190
ORA-06512: at line 1

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