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

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

After upgrading from 7.2.to 7.3.1.4  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
com.demantra.applicationServer.appServerExceptions.DateNotExistException:
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
es.java:580) at

Cause

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