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 184.108.40.206 to 220.127.116.11 [Release 7.3.0]
Information in this document applies to any platform.
After upgrading from 7.2.to 18.104.22.168 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 query.run: 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
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