BIP scheduled reports info

Sa12345

Summary

BIP scheduled reports info

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

Sherry George

Take a look at this document.

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

User910243567

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;

Sa12345

Hi Team,

any inputs on this please?

Thanks in Advance!

SK

Yogen

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.