Query to find Actual Processes and Target Processes and Status of Concurrent Manager

Query To Check Concurrent Managers Status 

How to check Concurrent Manager Status 

 In oracle apps dba job below query will be helpful to work for oracle concurrent manager.

By using this query you can find status of concurrent manager, Actual Processes and Target Processes etc.

So, as oracle apps dba you can use below query. 

 

SELECT fcqv.user_concurrent_queue_name "Concurrent Manager",
         fcq.TARGET_NODE "Node",
         fcq.running_processes "ACTUAL Processes",
         fcq.max_processes "TARGET Processes",
         DECODE (fcqv.control_code,
                 'D', 'Deactivating',
                    'E', 'Deactivated',
                         'N', 'Node unavai',
                              'A', 'Activating',
                                  'X', 'Terminated',
                                      'T', 'Terminating',
                                            'V', 'Verifying',
                                     'O', 'Suspending',
                              'P', 'Suspended',
                     'Q', 'Resuming',
                 'R', 'Restarting')
            status
    FROM apps.fnd_concurrent_queues fcq, apps.fnd_concurrent_queues_vl fcqv
   WHERE fcq.concurrent_queue_id = fcqv.concurrent_queue_id
         AND fcq.running_processes = fcq.max_processes
ORDER BY fcq.max_processes DESC;

 

  You can find me on Fiverr & LinkedIn

phase codes and status codes | Oracle Applications Concurrent Request

 

phase codes and status codes | Oracle Applications Concurrent Request

 

Table to find status code and phase code: FND_CONCURRENT_REQUESTS

Phase Code:

C	Completed
I	Inactive
P	Pending
R	Running

 

 Status Code:

A	Waiting
B	Resuming
C	Normal
D	Cancelled
E	Error
G	Warning
H	On Hold
I	Normal
M	No Manager
P	Scheduled
Q	Standby
R	Normal
S	Suspended
T	Terminating
U	Disabled
W	Paused
X	Terminated
Z	Waiting

You can find me on Fiverr & LinkedIn

How to find Concurrent Request submitted by a user

 

 

•  How to find Concurrent Request submitted by a user

• Query to find Concurrent Requests submitted by a specific  user

 

If you are looking for a query to find concurrent request that submitted by a specific user and the status of request with some additional info, Then you you can try this Query.

In this case you need to enter the user name and you will get required output

Query:

SELECT
user_concurrent_program_name,
responsibility_name,
request_date,
request_id,
phase_code,
status_code
FROM
fnd_concurrent_requests fndcr,
fnd_concurrent_programs_tl fndcp,
fnd_responsibility_tl fndr,
fnd_user fndu
WHERE
fndcr.CONCURRENT_PROGRAM_ID = fndcp.concurrent_program_id
and fndcr.responsibility_id = fndr.responsibility_id
and fndcr.requested_by = fndu.user_id
and user_name = upper(:user_name);

 

 

If anything else to know about this issue, Please comment below.

 

You can find me on Fiverr & LinkedIn