Troubleshooting Problems with Exporting the Forecast from Demantra To ASCP - Populate Denorm Table (Doc ID 1400029.1)

Last updated on AUGUST 05, 2016

Applies to:

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

Symptoms

General Context: Global & Local Forecast Data from DEMANTRA is meant to go to VCP / planning side / ASCP, as Demand Plan. This is a functional alternative for Local Forecasts in EBS that are collected to Planning / ASCP.

Issue with Upload of forecast to Denorm tabl:When attempting to upload Forecast the following error occurs:
Do execute step integration.log from java ORA-00911: invalid character; Collaborator.log:  Step name: 'PopulateDenormTable' - Error description 'Database internal error:ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast_with_app_id; - ORA-20003: Exception: msd_dem_upload_forecast.upload_forecast_with_app_id - Unable to find data profile ORA-01403: no data found'

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