1 Reply Latest reply on Apr 30, 2015 10:18 PM by Srini Chavali-Oracle

    Dataabse session for a Host based Concurrent Program

    Rakesh

      Hi,

       

      I am trying to find out the SID of a host based concurrent program but not able to do so.

       

      The following query doesn't fetch me any results. But this works when the requests call a package in database.

       

       

      SELECT * FROM V$SESSION

      WHERE PROCESS IN(SELECT OS_PROCESS_ID

                       FROM apps.FND_CONCURRENT_REQUESTS

                       WHERE REQUEST_ID='&REQ_ID')

       

       

       

      Can anyone please help me here?

       

       

      apps - 12.1.3

      DB 11.2.0.3

      OS - IBM AIX 6.1