Discoverer reports last run date and time
Good Morning! We are using EBS 12.1.3 and BI Discoverer Viewer Version 11.1.1.6.0. We are trying to find out Discoverer reports run last time. We want last date and time list of Discoverer report was accessed by EBS users.
We used following query to find out last run time details. But it is showing report creation date but not the last run date.The
QS_CREATED_DATE column is not giving the last run date.
SELECT STAT.QS_DOC_NAME,
STAT.QS_DOC_OWNER,
MAX(STAT.QS_CREATED_DATE),
COUNT(1)
FROM EUL5_US.EUL5_QPP_STATS STAT
GROUP BY STAT.QS_DOC_NAME,