Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Need to know the table name where to find number of times each discoverer report was run

Hello,
need help to find out answers for below questions, in which table I can find out these answers
Discoverer Reports: For all the disco reports.
- Number of times each report was run.
- Number of different users running the Report,’
- If possible, by username number of times they
have run the Report. - The last time the Report was run.
Oracle Report: Similar information for each Oracle report
Regards,
Meetu
Answers
-
For Discoverer, this is the "View SQL" for the report I run for query stats. Not sure if it will run as-is for someone else, but the relevant table is EUL5_QPP_STATS, owned by the Discoverer Administrator account.
SELECT NVL (O1176226.QS_ACT_ELAP_TIME, 0) / 60,
TRUNC (O1176226.QS_CREATED_DATE),
O1176226.QS_DOC_NAME || '-' || O1176226.QS_DOC_DETAILS,
O1176226.QS_ACT_CPU_TIME,
O1176226.QS_ACT_ELAP_TIME,
O1176226.QS_COST,
O1176226.QS_CREATED_BY,
O1176226.QS_CREATED_DATE,
O1176226.QS_DOC_DETAILS,
O1176226.QS_DOC_NAME,
(DECODE (O1176226.QS_STATE,
0, 'Cancelled',
1, 'Timed Out',
2, 'Completed')),
(O1176226.QS_NUM_ROWS),
SYS.DATABASE_NAME
FROM DISCADM.EUL5_QPP_STATS O1176226
WHERE (TRUNC (O1176226.QS_CREATED_DATE) BETWEEN
DECODE ( UPPER ( :"Start_Date"),'TODAY', TRUNC ( SYSDATE), TO_DATE ( :"Start_Date")) AND :"End_Date")
AND ( ( ( UPPER (O1176226.QS_CREATED_BY) LIKE :"User"
OR UPPER (O1176226.QS_CREATED_BY) IN ( ( :"User")))))
AND (UPPER (O1176226.QS_DOC_DETAILS) LIKE :"Worksheet")
AND (UPPER (O1176226.QS_DOC_NAME) LIKE :"Report Name")
ORDER BY O1176226.QS_CREATED_DATE DESC
-
Thank you so much let me check
-
do you how can we get these number for Oracle Reports?
-
No, sorry, can't help on that one.
-
There is a Blitz report SQL in our library showing this information: https://www.enginatics.com/reports/dis-worksheet-execution-history/
With regards to the Oracle reports history, these are run in EBS as background concurrent processes, and you can use a SQL like this to review the history (restrict to execution method='Oracle Reports'): https://www.enginatics.com/reports/fnd-concurrent-requests/