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 7.3.1.5 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!