Reporting - EBS (MOSC)

MOSC Banner

Bi Discoverer 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 when the Discoverer reports run last time. We want the last date and time the report was accessed.

We used the following query to find out last run time details. But it is showing the 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center