1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to find number of reports executed in Discoverer

Discussion in 'Oracle Discoverer' started by swapnilyeole, Nov 2, 2012.

  1. swapnilyeole

    swapnilyeole Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    125
    Hello,

    I want to find number of reports executed and which reports were ececuted during a particular period of time.

    Is there any way to find above required data?

    Please help.

    Thanks in advance.
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    May be the following code helpful to you

    Code (SQL):
    SELECT   fp.concurrent_program_name, fres.responsibility_name, flv.meaning,
             fr.completion_text, fr.output_file_type, fr.request_date,
             fr.requested_start_date, fr.actual_start_date,
             fr.actual_completion_date
        FROM fnd_concurrent_programs fp,
             fnd_concurrent_requests fr,
             fnd_responsibility_tl fres,
             fnd_lookup_values flv
       WHERE fp.concurrent_program_id = fr.concurrent_program_id
         AND fr.phase_code = 'C'
         AND fr.status_code = 'C'
         AND flv.lookup_code = fp.execution_method_code
         AND fres.responsibility_id = fr.responsibility_id
         AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
    ORDER BY fr.actual_start_date
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Kiran,

    Does this query for Discoverer reports or concurren programs at application level?
     
  4. swapnilyeole

    swapnilyeole Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    125
    Hello Kiran,

    The query gives all requests executed on application and not specifically on Discovrer.

    Can you please provide any alternative.

    Thanks,
    Swapnil
     
  5. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    What is the exact requirement ??

    Do you want discover report list which runs in discoverer or normal report in applications ???
     
  6. swapnilyeole

    swapnilyeole Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    125
    Hello Kiran,

    I want list of only those reports that were fired by users on discoverer during a particular time period.

    e.g.

    I want only those reports fired on discoverer on 07-November-2012.

    Thanks,
    Swapnil
     
  7. Sudheergbe

    Sudheergbe Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    150
    Hi Guys,

    This SQL gives the details of the discoverer report, who ran what report at what time.

    SELECT qs.qs_doc_owner username, qs.qs_doc_name workbook,
    qs.qs_doc_details worksheet, MAX (qs.qs_created_date) last_used
    FROM eul4_us.eul5_qpp_stats qs
    WHERE qs.qs_doc_name like '%Alex%'
    GROUP BY qs.qs_doc_owner, qs.qs_doc_name, qs.qs_doc_details


    Regards,
    Sudheer G