Technology Stack - EBS (MOSC)

MOSC Banner

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,

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