My Oracle Support Banner

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

Last updated on JANUARY 28, 2024

Applies to:

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


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'


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
  Solution Steps
 -  SYSGrants to apps:
 - Local, Multiple Forecast
 WF Steps and Troubleshooting
 - Series Names
 Check the workflow
 Run it
 Check the data
 Case Site

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.