Problem In Months Display In The Demantra Worksheets
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Demantra Demand Management - Version 18.104.22.168 to 22.214.171.124 [Release 7.3.0]
Information in this document applies to any platform.
After upgrading from 7.2.to 126.96.36.199 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 DB sales_data
This problem doesn't exists in sales_data table in the db
Moreover, the problem doesn't exists also when running the 'retrieve sql' of one of the WS.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms