After Report Trigger in BI Publisher

Question

Summary

Content

Hi

Oracle Business Intelligence 12.2.1.2.0

I want to capture the 'Report Output Generation' status and perhaps log an error/success in a custom table.
To make sure if the final output file is generated successfully

I don't want to depend on the 'After Data' Trigger as it gets fired even if the final output generation is failed.
For example, if there is an bug in the RTF Template Processing Instructions, But the XML Data got generated and 'After Data' trigger still gets fired.

Something like 'After Report' trigger in Oracle Reports Builder?
How can we achieve this in BI Publisher?

Note: We are using only BI Publisher and it is not an Oracle Apps Environment. So we may not have the capability of submitting Concurrent Requests

I also tried to depend on Bursting Query to call a function, but if there is an error in the RTF Template, Bursting Query is still getting executed

Thanks for any help
Sameer

Reghu.Kamal · Answer

Hi,

I have a similar requirement.

I want to run a report with a parameter as input, then the output should be in RTF template. Do we have any WS for this?  As I want to do it via WS

Regards

Reghu

Sameer.Darbha · Answer

The approach I mentioned above is working for my case

The Web Service is returning the contents of the file and based on it I can decide what action to take

Sameer.Darbha · Answer

I am trying another approach

After doing some research, I found that there is one Web Service 'Schedule Service'

http://host:port/xmlpserver/services/v2/ScheduleService?wsdl

with an operation 'getDocumentData()' which will take the job_id and return the byte[] of the output.

I am hoping to call this Web Service Operation from the Servlet and check if the actual output is generated properly or not

And based on that I am hoping to take appropriate action

Will update after I test this

Thanks

Sameer