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

using trigger for BIP report

Summary:

I am trying to use a trigger for a BIP report and schedule.

Content (please ensure you mask any confidential information):

I only want to deliver the report when there is data, but when I run it it always skips and I'm not sure why. The query should return when any new value has been created in the last 365 days, of which there is in fact data, but when I schedule the report to run with the trigger it always skips. When I run the query by itself in its own DM data is returned, so rownum greater than 0 would evaluate to true.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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