Hi Thanks. So it appears to be format mismatch From BI Publisher documentation 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…

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

Hi One option might be to browser extensions to set up auto-fresh at browser level. There are options to include html/javascript in analysis text fields in below OTBI documentation You can try to checking if javascript can be used for your requirement Regards, Prabhu

Hi By interactive reports do you mean the OTBI analysis. ? If yes you can review below documentation on adding various type of visual charts from an OTBI analysis Hope this helps Regards, Prabhu

Hi Milan Since this is posted in OTBI community by document/report do you mean BIP reports /OTBI analysis If yes you can review the following audit reports for BIP report and OTBI analysis BIP Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (KB61120) OTBI…

Hi All configuration values including BI Publisher memory guard settings are preset Review - Fusion Applications - BI Publisher Memory Guard Best Practices (Doc ID 2472630.1) Oracle Fusion BI Publisher: BI Publisher Memory Guard Settings On SaaS (Doc ID 2199494.1) Regards,