My Oracle Support Banner

No Demantra Forecast Generated - Common Issues (Doc ID 848205.1)

Last updated on JUNE 21, 2023

Applies to:

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


This note is intended to talk about scenarios where no Demantra forecast appears to have been generated.

The Oracle Demantra application requires item, location and demand (sales) data.  Given the required minimum data, run the full data load procedures; EBS Full Download, ep_load package, ep_load_main wrapper procedure, etc.  The  engine should be able to be executed returning forecast data results.  Note that the data load procedures and/or engine run should set all necessary date parameters like  max_fore_sales_date, max_sales_date, last_date, etc. based on the data being provided and should not require any manual intervention.

Date parameters should not be changed manually and instead the data, if no recent data has been provided, should be manually changed in the staging tables before it enters Demantra to reflect meaningful dates for Proof of Concept or Demonstration. 


This note is intended for those users responsible for monitoring and/or analyzing the output of the Demantra Analytical Engine


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
 1) The Forecast Engine actually failed which is why no forecast was generated
 2) The Forecast Engine succeeded but it did not create 'future' time buckets in the Sales_Data table.
 3) The Forecast Engine succeeded and future time buckets are created but no forecast values are observed in the Demantra Worksheet.
 4) Comments on manually changing parameters like Max_Sales_Date, Last_Date, etc. to compensate for incomplete client data
 5) What to upload to Oracle Support if this note doesn't help you to solve the issue.

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