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

Is it possible to control email notifications in the report scheduler based on data model results?

Received Response
1
Views
1
Comments

Summary:

When scheduling a BI Publisher Report, I only want to send an email notification to designated users when the report returns data. Is this possible?

Content (required):

I created a "troubleshooting" report and need to schedule it. However, I only want Oracle to send an email notification to designated users when the report returns data. When the report does NOT return data, it means that there are not any data issues that need to be resolved, so I do not want any users to be emailed. My data model is based on a very long SQL query that links numerous tables.. I thought that I could create a trigger, but it does not look like I can create a trigger based on

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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