You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Publisher Report Job Skips even if there is data in the trigger and model

Received Response

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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!