My Oracle Support Banner

Local Forecast Integration Profile fails with Exception in class TempDatesList - method TempDatesList() : Date not available. (Doc ID 2545948.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 12 version, LoadData

ACTUAL BEHAVIOR
---------------
Trying to load Forecast data from Demantra into ASCP through integration profile Local Forecast integration but it fails with the following error in the logs

2019-04-09 08:42:51,249 CDT [WFProcess_319] FATAL workflow.general: appserver.workflow.general
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: Exception in class TempDatesList - method TempDatesList() : Date not available.
at com.demantra.applicationServer.services.tempTable.TempDatesList.setTempDatesList(TempDatesList.java:67)
at com.demantra.applicationServer.services.queryrun.TablesHandler.setDateList(TablesHandler.java:71)
at com.demantra.applicationServer.services.queryrun.AbstractDataHandler.setTempDatesList(AbstractDataHandler.java:184)


EXPECTED BEHAVIOR
-----------------------
The Forecast from Demantra should be loaded correctly into ASCP.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the standard workflow EBS Load Local Forecast.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the plan is not seeing the correct forecast demand and therefore the shop floor cannot build the correct amount of product.

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!


In this Document
Symptoms
Cause
Solution


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