No Output When Adding Parameters in the Bursting Query

Chris Carloff

This is my snippet of my added code. Both SUCCESS SCHEDULE

USING HARDCODED DATES

USING LINE2 PARAMETER

Prabhu Krishnamoorthy -Oracle

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

Chris Carloff

@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.

Prabhu Krishnamoorthy -Oracle

Hi

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

Regards,

Prabhu