BIP scheduled reports info — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP scheduled reports info

Received Response
51
Views
4
Comments
Sa12345
Sa12345 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Take a look at this document.

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

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    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
    Sa12345 Rank 3 - Community Apprentice

    Hi Team,

    any inputs on this please?

    Thanks in Advance!

    SK

  • Yogen
    Yogen Rank 5 - Community Champion

    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.