Query for Concurrent List in Oracle R12

Hi,

Today, i want to post about concurrent listing query. It will be used to find concurrent name, with some additional field about executable name, executable path name. And also RTP template name, while the concurrent have related with XML publisher.

/* 
Created by = Andreas Victor (www.andreasvictor.net) 20151212
Purpose = Query concurrent list with some fields about executable name and rtf template
*/

SELECT fcpt.user_concurrent_program_name,
       fcpt.description,
       fcp.output_file_type type,
       fcp.output_print_style style,
       fa.application_short_name app,
       fe.executable_name,
       fe.execution_file_name,
       (
       select template_code
        from XDO_DS_DEFINITIONS_TL xdt, XDO_TEMPLATES_B xtb
        where xdt.data_source_code = xtb.data_source_code
        and xdt.data_source_code = fe.executable_name
        and rownum=1
       )rtf_template,
       fcp.creation_date,
       fu.user_name created_by,
       fcp.last_update_date
FROM   fnd_concurrent_programs fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_application fa,
       fnd_executables_form_v fe,
       fnd_user fu
 WHERE 1=1
   AND fcpt.concurrent_program_id = fcp.concurrent_program_id
   AND fa.application_id = fcp.application_id
   AND fcp.executable_id = fe.executable_id
   AND fcp.created_by = fu.user_id
   AND UPPER(fcp.concurrent_program_name) = :p_concurrent_name
   AND fcp.enabled_flag = 'Y'
 ORDER BY fcp.creation_date DESC;
   

When i need to monitor the running concurrent, i have used this query.

SELECT *
FROM (
SELECT fcr.request_id,
       fcr.request_date,
       fcpt.user_concurrent_program_name,
       fcp.concurrent_program_name,
       fcpt.description,
       fa.application_short_name app_short_name,
       fcr.phase_code,
       fcr.status_code
--       fcp.*
--       fcr.*
  FROM fnd_concurrent_requests fcr,
       fnd_concurrent_programs fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_application fa
 WHERE 1=1
   AND fcp.concurrent_program_id = fcr.concurrent_program_id
   AND fcpt.concurrent_program_id = fcp.concurrent_program_id
   AND fa.application_id = fcp.application_id
   AND UPPER(fcp.concurrent_program_name) like '%ACCOUNTING%'
)aa
ORDER BY aa.request_date DESC      
;

I hope it can be used to my blog reader. Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s