How to execute a BI Publiser job on demand from an external process

Question

Hi all,

I have several BI Publisher reports configured to export their output as .csv files directly to OCI Object Storage buckets.

However, I now have a requirement where these jobs must be triggered on demand, rather than on a scheduled basis.

Is there a supported or recommended way to execute these BI Publisher jobs via a shell script or command-line interface to meet this on-demand execution need?

Any insights, examples, or references would be greatly appreciated.

Thank you in advance for your support.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/69290#Comment_69290

Hi Alvaro,

Have you created ESS jobs for these BIP reports and you are looking to trigger these ESS jobs from an external system?

If yes, then below links should be helpful:

Submit Oracle Fusion Cloud ESS processes using REST Webservices | Oracle Cloud Sunil Kumar Blogs

Infosys Cobalt | Exploring Oracle Cloud ESS Job REST API

How to Submit ESS Process Using Web Services in Fusion Applications? (Doc ID 2261832.1)

Otherwise use the REST APIs shared in abvoe post.

Thanks.

Alvaro_Soares · Answer

Hi Wayne,

Thank you for reaching out and the URL sent.

However, the method is mentioning Run report and not a run job.

Is there any way to run a Publisher job ?

Thank you

Wayne Van Sluys · Answer

Take a look at the Rest API commands

https://docs.oracle.com/en/middleware/bi/analytics-server/oap_rest_api/op-v1-reports-reportpath-run-post.html