Query to get the Discoverer Scheduled jobs with User details

Oracle Discoverer Reports Schedule details with User for SOX Audit

You may want to be able to audit log which user has scheduled a specific workbook/ Discoverer report.

If you want to query information about user that has scheduled a report / discoverer workbook:

Query:

SELECT ebr.br_job_id, dj.job "DBA_JOB", ebr.br_created_by
      ,CASE
         WHEN INSTR (ebr.br_created_by, '#') = 0
           THEN ebr.br_created_by
         WHEN INSTR (ebr.br_created_by, '#') > 0 AND INSTR (ebr.br_created_by, '#', 2) = 0
           THEN (SELECT fu.user_name
                   FROM fnd_user fu
                  WHERE fu.user_id = SUBSTR (ebr.br_created_by, 2, 9))
         ELSE NULL
       END "BR Owner/Creator - USER"
      ,dj.what,dj.broken, ebr.br_name, ebr.br_workbook_name, ebr.br_description, ebr.br_created_date, ebr.br_next_run_date, dj.next_date "DBA_JOB_NEXT_DATE", ebr.br_completion_date, ebr.br_updated_by
      ,CASE
         WHEN INSTR (ebr.br_updated_by, '#') = 0
           THEN ebr.br_updated_by
         WHEN INSTR (ebr.br_updated_by, '#') > 0 AND INSTR (ebr.br_updated_by, '#', 2) = 0
           THEN (SELECT fu.user_name
                   FROM fnd_user fu
                  WHERE fu.user_id = SUBSTR (ebr.br_updated_by, 2, 9))
         ELSE NULL
       END "BR Updated by - USER"
      ,ebr.br_updated_date
  FROM EUL_OWNER.eul5_batch_reports ebr, dba_jobs dj
WHERE ebr.br_job_id = dj.job AND dj.broken = 'N';

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