Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP scheduled reports info
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
-
Take a look at this document.
https://docs.oracle.com/cd/E23943_01/bi.1111/e22257/view_manage_rpt_jobs.htm#BIPUG224
0 -
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;
0 -
Hi Team,
any inputs on this please?
Thanks in Advance!
SK
0 -
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.
0