Developing external application to communicate with Oracle BI Publisher

Question

Summary

Content

For my understanding, we can use a web service
(ScheduleService, ReportService,SecurityService and CatalogService) to
communicate Oracle BI Publisher for manipulating scheduler to generate a
report.

May i know

* is it an implementation of Oracle BI Presentation
Services? 
* if so is it a single way to communicate with Oracle BI in
order to trigger the Oracle BI scheduler?
* does it have an alternative to communicate with Oracle BI
Publisher from external application?
* Any reference / sample recommended?

Thanks in advance

Thomas Dodds · Answer

We call BI Publisher Scheduling Service from Control-M ... use it to put in a scheduled run once job daily.

Here's the Oracle Docs ...

https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002

Venkat Thota - BIP · Answer

if possible can you able to share java code here, Thanks

Ravi Chamarty · Answer

Hi,

As I mentioned, I didn't develop the JAVA code to do it. but, when we raised Oracle SR, they shared the documentation and methodology

for all the JAVA APIs handbook that could be call BI Publisher reports, define the layouts and email/schedule them to the recipients.

Also, caching of the data, caching of the report layouts,  we also had a issue where report time out was occurring after 3 min if the data volume was more, performance issues were there if the report export to excel for more than 15,000 rows were there all this we discussed and resolved after talking to Oracle support. I don't have it since it was done in 2013 and for a different customer.

Raise an Oracle SR they would be able to help for the same