Forum Stats

  • 3,851,945 Users
  • 2,264,053 Discussions
  • 7,904,914 Comments

Discussions

Need query for Discoverer reports

User_14MG0
User_14MG0 Member Posts: 22 Blue Ribbon
edited Dec 11, 2015 8:14AM in Discoverer

Hi All,

I need SQL query to find out all the discoverer reports with report name, start date & time, end date & time, parameters, how much time reports took to complete.

Please help on this.

Thanks.

Answers

  • Bashar.
    Bashar. Member Posts: 2,502 Silver Crown
    edited Dec 10, 2015 5:21AM

    Hi,

    You may want to post your question in the Discoverer forum:

    Regards,

    Bashar

  • User_14MG0
    User_14MG0 Member Posts: 22 Blue Ribbon
    edited Dec 10, 2015 6:03AM
  • Hussein Sawwan-Oracle
    Hussein Sawwan-Oracle Member Posts: 69,485 Employee
    edited Dec 10, 2015 2:01PM

    Is this what you're looking for?

    How To Enable Query Statistics / Query Prediction / Audit Logging For Discoverer Worksheets (Doc ID 1340849.1)

    How to Know All the Discoverer Reports Respective View Names of Oracle E-Business Suite (Doc ID 1640937.1)

    How To Get A List Of Discoverer Worksheets Directly From The Database? (Doc ID 1333531.1)

    How to Find Out the Sharing Information for Discoverer workbooks From the Database (Doc ID 293021.1)

    How To Find Out Who The Owner of a Workbook is and To Whom it is Shared (Doc ID 1076907.6)

    How To Audit or Log User's Access Information or Changes to A Discoverer Workbook (Doc ID 730424.1)

    How To Query Metadata To Determine Which Discoverer Workbooks Are Accessible To User (Doc ID 433794.1)

    https://community.oracle.com/thread/2202172

    Thanks,

    Hussein

This discussion has been closed.