Exporting Incremental Forecast From Demantra is Erroring Out. (Doc ID 603947.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
***Checked for relevance on 21-DEC-2010***


Symptoms

On 7.2 in Production:
When attempting to run the workflow for Exporting Forecast from Demantra to ASCP.,
the following error occurs:

ERROR
Process ID: 2562 Schema ID: 1153 Schema name: ''Fcst Exp ASCP'' Step ID: ''PopulateDenormTable''
Step name: ''PopulateDenormTable'' Error description ''Database internal error: ORA-20015:
Exception: msd_dem_upload_forecast.upload_forecast - ORA-20005: Error:
: msd_dem_upload_forecast.upload_forecast - Incremental export type is not supported''.

STEPS
The issue can be reproduced at will with the following steps:
1. Configure the Export Integration interface with the Export Type as 'incremental'.
2. Mention the series, levels, date range and the BIEO table details.
3. Run the workflow for the export integration interface containing the Transfer Step and the
Populate Denorm Table using the stored procedure step.
4. Check for any error in the Collaborator Workbench --> My Tasks


BUSINESS IMPACT
The issue has the following business impact:
Unable to export the incremental forecast to ASCP, which is required as part of the business
process and we have a solution using the same. Hence this would cause a limitation.

.

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