Query to get Oracle Concurrent Program completion time:

select  user_concurrent_program_name,

(round((actual_completion_date - actual_start_date)*24,2)) completion_hrs,

(round((actual_completion_date - actual_start_date)*24*60,2)) completion_mins,

actual_start_date, 
actual_completion_date,
argument_text parameters,
a.* 
from apps.fnd_concurrent_requests a,

apps.fnd_concurrent_programs_tl b

where a.concurrent_program_id = b.concurrent_program_id

and user_concurrent_program_name = 'XXX Program Name'

order by requested_start_date desc;