title: Trying to get the latest execution of a concurrent (oracle 11g)
body: <p>I am trying to obtain the latest execution of a specific concurrent; i am connecting to an <strong>Oracle 11g database</strong>.</p>
  
  <p>My query works just fine but for some reason i was not able to obtain only the latest execution, i mean the <strong>request_id</strong></p>
  
  <p><strong>This my query:</strong></p>
  
  <pre><code>select nam.user_concurrent_program_name program,
         con.request_id "request id",
         to_char(con.actual_start_date, 'dd/mm/yyyy hh24:mi') start,
         to_char(con.actual_completion_date, 'dd/mm/yyyy hh24:mi') end,
         trunc((con.actual_completion_date - con.actual_start_date) * 1440, 2) time_mm,
         con.status_code status,
         us.user_name user,
         con.oracle_process_id,
         con.oracle_session_id,
         con.argument_text
    from fnd_concurrent_programs_tl nam,
         fnd_concurrent_requests    con,
         fnd_user                   us
   where con.concurrent_program_id = nam.concurrent_program_id
     and con.requested_by = us.user_id
     and con.actual_start_date &gt;= to_date('20/11/2019', 'dd/mm/rrrr')
     and con.actual_start_date &lt; to_date('23/11/2019', 'dd/mm/rrrr') + 1
     and nam.user_concurrent_program_name like 'report concurrent sales'
     and co.request_id =
         (select max(con.request_id)
            from fnd_concurrent_requests can
           where con.request_id = can.request_id);
  </code></pre>
  
  <p>The problem is that i am getting several rows and i only want the latest row, with the highest request_id.</p>
  
  <p>Could you please help me?</p>