Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Executing a report job based on new record in DB table

Summary
Executing a report job based on new record in DB table
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
Answers
-
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
0 -
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
0