My Oracle Support Banner

Problem In Months Display In The Demantra Worksheets (Doc ID 1611108.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Demantra Demand Management - Version to [Release 7.3.0]
Information in this document applies to any platform.


After upgrading from  Customer has a monthly bucket
when looking at the worksheets, October (both in 2013 and 2014) is represented as 30/9/2013 instead of 1/10/2013. Same for 30/9/2014 instead of 1/10/2014.
The other months looks fine.
The data which exists in the 30/9 rows correspond to the October line in the  sales_data
This problem doesn't exists in sales_data table in the database
Moreover, the problem doesn't exists also when running the 'retrieve sql' of one of the worksheet.
There is no error in collaborator.log or java console output for this worksheet.
But when trying to change the time in worksheet to be From Date and Until Date to be 1/10/2013, the worksheets shows errors and also bellow error shows up
in collaborator.log file :
2013-12-19 16:35:02,786 IST [DataRunner_139] ERROR ODPM-70016:
Error loading query from Application Server:ODPM-10047: The given record date
is not valid for the queryODPM-10207: Invalid Dates for 12602_11
ODPM-10047: The given record date is not valid for the queryODPM-10207:
Invalid Dates for 12602_11 at
com.demantra.applicationServer.util.DateTimeServices.getEndDate(DateTimeServic at




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

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