This discussion is archived
1 Reply Latest reply: Dec 19, 2012 1:53 AM by Sridhar 1245 RSS

Can we schedule BI publisher report through pl/sql?

689515 Newbie
Currently Being Moderated
If any new user is created and given "schedule report" privilege,
instead of logging to bipublisher portal with the user's id and scheduling individual report I want to have a pl/sql package which when fired, if finds any new user should run those reports and save output for the user.

For these I should call the bipublisher report in pl/sql through scheduler schema, set parameter values, provide run_interval, output_format etc.
Please let me know if this is possible and also give example code.

This is urgent requirement. Please reply ASAP.

Thanks and Regards.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points