OTBI Publisher Report Job Skips even if there is data in the trigger and model
Summary: Oracle BI Publisher Report Job which is scheduled every 30 minutes gets skipped even if data is returned by the trigger
Content (required): I have a scheduled report job in Oracle BI Publisher. It is scheduled to run every 30 minutes. The data model contains a trigger because the requirement is to output an email with the report only if there is data returned by the SQL query. If there is no data returned by the data model, report job should skip. However, the report job gets skipped even if the data model and trigger return data. I do have a timezone conversion in my code. I am not sure if that is causing the report job to skip. Please see