Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Saturday, July 11, 2015

Query to get concurrent job completed and pending

SELECT fcr.request_id,
       fcpv.user_concurrent_program_name,
       fcpv.concurrent_program_name,
       fcpv.concurrent_program_id,
       fcr.status_code,
       fcr.phase_code
  FROM fnd_concurrent_programs_vl fcpv,
       fnd_executables fe,
       sys.dba_dependencies dd,
       fnd_concurrent_requests fcr
 WHERE     fcpv.executable_id = fe.executable_id
       AND fe.execution_method_code = 'i'
       AND SUBSTR (fe.execution_file_name,
                   1,
                     INSTR (fe.execution_file_name,
                            '.',
                            1,
                            1)
                   - 1) = UPPER (dd.name)
       AND dd.referenced_type IN ('view',
                                  'table',
                                  'trigger',
                                  'package')                -- add as required
       --and referenced_owner = 'xxcus'
       AND dd.referenced_name = UPPER ('&package_name')
       AND fcr.concurrent_program_id = fcpv.concurrent_program_id

       AND fcr.phase_code NOT IN ('c', 'p');

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect