SOX Audit Report : Oracle Discoverer Reports access/execution History With User Details

Oracle Discoverer Reports Access/Execution History for SOX Audit

You may want to be able to audit user's access information to run Discoverer worksheets to a specific workbook.

If you want to query information about users who have executed a specific report:

Query:

SELECT   qs_doc_name AS "Workbook Name", qs_doc_details AS "Worksheet Name"
        ,CASE
           WHEN INSTR (qs_created_by, '#') = 0
             THEN qs_created_by
           WHEN INSTR (qs_created_by, '#') > 0 AND INSTR (qs_created_by, '#', 2) = 0
             THEN (SELECT fu.user_name
                     FROM fnd_user fu
                    WHERE fu.user_id = SUBSTR (qs_created_by, 2, 9))
           ELSE NULL
         END "Worksheet Run By"
        ,qs_created_date "Run Date"
    FROM EUL_OWNER.eul5_qpp_stats
   WHERE LOWER (qs_doc_name) LIKE LOWER ('%oracle%') --Enter Workbook Name Here
     AND qs_created_date >= TO_DATE ('01-APR-2016 00:00:00', 'DD-MON-YYYY HH24:MI:SS')
     AND qs_created_date <= TO_DATE ('30-APR-2016 23:59:59', 'DD-MON-YYYY HH24:MI:SS')
   --AND qs_created_date >= (SYSDATE - 10)
ORDER BY qs_created_date DESC;

Note : Replace EUL_OWNER with corresponding EUL owner of your environment in above query.

This query will give the output with users details who have executed a specific report from 01-APR-2016 to 30-APR-2016.