BIP scheduled reports info

Question

Summary

Content

HI Team,

We have many BI Publisher reports scheduled. We need to get the information like start date, frequency, recipients , subject etc  about all the scheduled reports.  Instead of opening each report and check is there any way to get the information of all the scheduled reports at a time? please help me in getting this information.

Thanks,

SK

Yogen · Answer

Best way to do this is to create opaque view in RPD using the XMLP meatadata tables. Create opaque view using those 7-8 tables, you will have to convert BLOB columns into varchar type columns  to get the most of the info.

Sherry George · Answer

Take a look at this document.

https://docs.oracle.com/cd/E23943_01/bi.1111/e22257/view_manage_rpt_jobs.htm#BIPUG224

User910243567 · Answer

You can use below query

SELECT fcr.request_id,fcp.user_concurrent_program_name,  fcr.concurrent_program_id,  fcr.requested_by,  fcr.actual_start_date,  fcr.actual_completion_Date,  (NVL(fcr.actual_completion_Date, SYSDATE)- fcr.actual_start_date)*24*60 MInutes,  fcr.status_code, fcr.ARGUMENT_TEXT, fcr.requested_start_date,fcp.output_file_typeFROM applsys.fnd_concurrent_requests fcr, fnd_concurrent_programs_vl fcp WHERE fcr.concurrent_program_id = fcp.concurrent_program_idAND fcr.requested_start_date >= SYSDATEAND fcp.output_file_type = 'XML'ORDER BY fcr.request_date desc;