This content has been marked as final. Show 5 replies
Yes you can try any of the below 3 steps
1)login into the OAS console,click the report server and check the failed as well successful reports run
2nd using the below url
3rd Get Reports Server Queue Content in XML Format (Metalink [ID 239574.1])
Thank you for your reply. But I want to this report with PL/SQL. I mean I run a command like "select report_name, file_name from reports where status='FINISHED'". Is this possible?
I want to open http://hostname:port/reports/rwservlet/showjobs?server=<report_server_name> URL. Then the page asks me username, password. I login with PORTAL but I have following error:
REP-50201: Cannot get user role from OID server.
Which user should I login?
Edited by: ilke_altinpulluk on 12.Mar.2013 08:40
I want to get finished reports list from application server. For example maybe from metadata repository database (select report_name, file_name from >reports where status='FINISHED'). Can I reach this data?Yes you can,
Follow the below metalink note:
*Using the Reports Server Queue PL/SQL Table and API - RW_SERVER_JOB_QUEUE [ID 72531.1]*
Two steps are required to activate the feature:
1.- Prepare the database and get set of objects created
2.- Configure the Reports Server to work with the specific database schema
REP-50201: Cannot get user role from OID server.Follow the below metalink note for the same
*Rep-50201: "Cannot Get User Role From Oid Server" When Trying Showmyjobs [ID 343225.1]*
Both the Metalink notes will be helpful for ya
Thank you Fabian. The problem was solved.