Workflow To Upload Global Forecast From Demantra To ASCP Not Populating Table MSD_DP_SCN_ENTRIES_DENORM (Doc ID 457322.1)

Last updated on NOVEMBER 13, 2024

Applies to:

Symptoms

Users are trying to publish the Demantra forecast back to the MSD (Old Oracle Demand Planning) in order to be able to use if for an ASCP plan run. However the forecast is not getting populated into table MSD_DP_SCN_ENTRIES_DENORM, so the forecast will not be seen in the list of values for ASCP to choose from. In debugging the program MSD_DEM_UPLOAD_FORECAST (msddemufs.pls , msddemufb.pls) we found this program is expecting the VALIDATION_ORG_ID field in the MSC_APPS_INSTANCES table to be populated. This field can not be setup at the front end when defining the instances.  In the user's case the column VALIDATION_ORG_ID field in the MSC_APPS_INSTANCES table is null.

Users updated this field on the back end to see if the forecast upload works. The upload worked.  But when they ran the ASCP collection next time, the VALIDATION_ORG_ID field became NULL.


STEPS
1. Generate the forecast via the Demantra Analytical Engine
2. Try to upload the forecast with workflow MSD_DEM_UPLOAD_FORECAST
3. Review table MSD_DP_SCN_ENTRIES_DENORM and no demantra forecast records are found

Changes

Cause

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