5 Replies Latest reply: Mar 13, 2013 8:01 AM by ilke_altinpulluk RSS

    Table of Reports

    ilke_altinpulluk
      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
          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
            ilke_altinpulluk
            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
              ilke_altinpulluk
              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
                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
                  ilke_altinpulluk
                  Thank you Fabian. The problem was solved.