How to check status of a concurrent Request

How to check status of a concurrent Request
------------------------------------------------------------
You can check the status of concurrent request from front end using the application login.

System Adminstrator---->Concurrent --->Request--->View Specific Request
(In the field enter the concurrent request id known to you.If you dont know the concurrent request id,ask the person who is facing the issues with which request id)
After getting the request id,please enter the req.id.click button Find below to it.You will get the status of the Req.Id.Also review the log and output file for the clarification.

From Back End (sqlplus apps/apps)You can also check this.

SQL> select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=100392843;

REQUEST_ID P S ORACLE_SESSION_ID
---------- - - -----------------
 100392843 R R          11643001

SQL> select sid,serial#,action,status from v$session where audsid=11643001;

       SID    SERIAL# ACTION                           STATUS
---------- ---------- --------------------------------          --------
       716      21679 Concurrent Request               ACTIVE

-------------------------------------------------------------
How to check Pending Concurrent Requests
------------------------------------------------------------
set pagesize 2000
set linesize 512
column QUEUE_DESCRIPTION format a45
column "CONCURRENT Manager"  format a45 HEADING "Concurrent|Manager"
column "Queue ID"  format 999999999 HEADING "Concurrent|Queue ID"
column "Apps ID"  format 999999 HEADING "Apps|ID"
column NODE format a15
column Phase format a10
column count(1)  format 9999999 HEADING "Requests|Count()"
SELECT a.CONCURRENT_QUEUE_ID "Queue ID",
           a.QUEUE_APPLICATION_ID "Apps ID",
           b.user_CONCURRENT_QUEUE_NAME "Concurrent Manager",
           b.TARGET_NODE "NODE",
    decode(a.PHASE_CODE, 'P','PENDING',
                        'R','Running'
          ) Phase,b.Running_Processes Running,b.Max_Processes Max_processes
    ,count(1)
     FROM apps.FND_CONCURRENT_WORKER_REQUESTS a, apps.fnd_concurrent_queues_vl b
   WHERE (a.Phase_Code = 'P' or a.Phase_Code = 'R')
   and a.hold_flag != 'Y'
    and a.Requested_Start_Date <= SYSDATE
    AND ('' IS NULL OR ('' = 'B' AND a.PHASE_CODE = 'R' AND a.STATUS_CODE IN ('I', 'Q')))
   and '1' in (0,1,4)
   And a.concurrent_queue_id=b.concurrent_queue_id
    group by a.CONCURRENT_QUEUE_ID,
            a.QUEUE_APPLICATION_ID,
            b.user_CONCURRENT_QUEUE_NAME,
             b.TARGET_NODE,
              a.PHASE_CODE,b.Running_Processes,b.Max_Processes
   order by 1;