Executing a report job based on new record in DB table

Question

Summary

Content

Executing a report job based on new record in DB table

We have generate and send a report to email based on a new record insertion in a table. We will need to use the values inserted in the table as parameters in the report as well. Any pointers will be highly appreciated. Thanks

timdexter · Answer

Just adding to 2807661's answer.

Its not a push to run the report as soon as there is a new record in the table. Its a case of setting up a BIP report with the trigger to look for a new record and putting that on a very regular schedule. IF you are expecting new records every hour then set the schedule for 30|15|10 mins so that the most a record has to wait to be published is 30|15|10 mins. You can write a query to retrieve the data from the new record to pass the values to a second query as paramters.

If you want a true push then you are going to have to create a plsql web services sub program to call BIP via its web services. Its some work to set up but could then be leverage through the DB to run reports from PLSQL and SQL.

Tim

Venkat Thota - BIP · Answer

You can achieve requirement with schedule Trigger concept https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM389 (creating scheduled trigger). This trigger is associated with sql query , if it returns rows then job will be executed else terminate , you can define sql query if new row is inserted then return data to execute report job. Thanks