This is my snippet of my added code. Both SUCCESS SCHEDULE
USING HARDCODED DATES
USING LINE2 PARAMETER
Hi
Just to test if it is a datatype issue , can you check if below format works
WHERE TRUNC(htrgs.START_TIME) BETWEEN TO_DATE(:p_startDate, 'DD/MM/YYYY') AND TO_DATE(:p_endDate, 'DD/MM/YYYY')
You can also capture diagnostic log to check the processing
Regards,
Prabhu
@Prabhu Krishnamoorthy -Oracle Hi, Thank you for your response, it shows error when running the DM,
Also this is the Diagnostic if using the the Parameter above.
Thanks. So it appears to be format mismatch
From BI Publisher documentation https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-69D7FAA1-1C7E-4683-AC4A-D796D2483687.htm
Oracle BI Publisher always binds date column or date parameter as a timestamp object.
To avoid timestamp conversion, define the parameter as a string and pass the value with formatting as 'DD-MON-YYYY' to match the RDBMS date format.
Hope this helps
