2 Replies Latest reply on May 3, 2015 9:49 AM by Kirushna

    How to Get SID of Host based Concurrent Request

    Rakesh

      Hi ,

       

      I can get the SID of any running concurrent request by followig query.

       

       

      SELECT * FROM V$SESSION

      WHERE PROCESS IN(SELECT OS_PROCESS_ID

                       FROM apps.FND_CONCURRENT_REQUESTS

                       WHERE REQUEST_ID='&REQ_ID')

       

       

      But i am having troublw when the the program is host based i.e it executed a .porg file in server. Does any one have nay idea how can i get the SID for such requests?

       

      pcm01:/home/applmgr # ps -ef|grep -i 12884605

        applmgr 24969326  2689516   0 15:24:29  pts/5  0:00 grep -i 12884605

        applmgr 54985588  5310460   0 13:28:56      -  0:00 sh -- /app/prd/apps/apps_st/appl/xxar/12.0.0/bin/XXRUSB.prog APPS/**** 7791 USER 12884605 28-APR-2015 28-APR-2015 WR Y Y Y

       

      If i do a grep for requet id on CM node, I get the OS process, BUt i can't get the SID.

       

      Any suggestions?