Tuesday, 5 July 2016

Oracle BI Publisher reports not showing up data unless we change the report output format



We have an Oracle Retail Sales Audit 14.1 (ReSA) application which has some pre-built operational insights reports.  These are OBIEE/Oracle BI Publisher reports for Sales Auditors or Financial managers.

While validating the ReSA application one of the user comes up with a question asking "When I try to view a report from the ReSA application it shows a blank BI Publisher report and if only I change the report format to PDF or html it shows up the report data.

After doing some R&D, I found the reason - it is because of the report level property "Auto Run" marked unchecked


 Auto Run - This feature will not allow the report to execute immediately when user opens the report.  This will prompt the user to select parameter values before it actually runs the report