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,
O1176226.QS_DOC_NAME || '-' || O1176226.QS_DOC_DETAILS,
1, 'Timed Out',
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/