This discussion is archived
5 Replies Latest reply: Mar 13, 2013 6:01 AM by 761281 RSS

Table of Reports

761281 Newbie
Currently Being Moderated
Hi all,
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?
  • 1. Re: Table of Reports
    Fabian Pro
    Currently Being Moderated
    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
    or

    2nd using the below url
    http://hostname:port/reports/rwservlet/showjobs?server=<report_server_name>

    or
    3rd Get Reports Server Queue Content in XML Format (Metalink [ID 239574.1])
    http://hostname:port/reports/rwservlet/showjobs?server=<report_server_name>&statusformat=XML

    Regards
    Fabian
  • 2. Re: Table of Reports
    761281 Newbie
    Currently Being Moderated
    Hi Fabian,
    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?
  • 3. Re: Table of Reports
    761281 Newbie
    Currently Being Moderated
    Hi Fabian,
    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:

    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
  • 4. Re: Table of Reports
    Fabian Pro
    Currently Being Moderated
    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

    Regards
    Fabian
  • 5. Re: Table of Reports
    761281 Newbie
    Currently Being Moderated
    Thank you Fabian. The problem was solved.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points