null date parameter issue when connecting to Oracle Database 12.2

Hello,

We are using BI Publisher which is part of: Oracle Business Intelligence 11.1.1.7.150120 on linux.

We recently upgraded to Oracle Database 12.2 from 11.2 and we ran into an odd issue.

For text parameters that are treated as date (i.e. parameter is defined as Text but user is supposed to enter mm/dd/yyyy) we started getting "invalid month" error from the data model.

The report in question has been in production for a long time and no change was made to it.

The SQL where condition is like this:

(:P_BATCH = 'ALL'

AND table1.column1 between BETWEEN to_date( :P_STARTDATE ||' 00:00:00' , 'MM/DD/YYYY HH24:MI:SS')