Who let the dogs out ....when, and for how long..?

.

Okay, thats a catchy title for post, simple SQL to find out who ran the concurrent program and when.

SELECT FCON.concurrent_program_name
      ,FCON.user_concurrent_program_name
      ,FREQ.request_id
      ,FREQ.requested_by
      ,(SELECT FUSE.user_name||' ['||FUSE.description||']'
          FROM fnd_user FUSE 
         WHERE FUSE.user_id = FREQ.requested_by) user_name
      ,TO_CHAR(FREQ.requested_start_date,'DD-MON-RRRR HH24:MI:SS')    req_start_dt
      ,TO_CHAR(FREQ.actual_start_date,'DD-MON-RRRR HH24:MI:SS')       act_start_dt
      ,TO_CHAR(FREQ.actual_completion_date,'DD-MON-RRRR HH24:MI:SS')  act_compl_dt
      ,FREQ.argument_text
  FROM fnd_concurrent_requests FREQ
      ,fnd_concurrent_programs_vl FCON
 WHERE FCON.concurrent_program_id   = FREQ.concurrent_program_id
   AND FCON.concurrent_program_name = 'CONC_PROGRAM_NAME'
 ORDER BY FREQ.request_id DESC

.
Cheers