3 Replies Latest reply on Apr 9, 2019 1:39 PM by Bommi

    Concurrent Requestor - EBS R12

    Ayman.Bagha

      Dears,

      How to find requests that run by specific requestor?

      As when I use System Administrator >Concurrent> Requests, I can search by a requestor. But when using View> Requests, I cannot search by other user expect my user.

       

      Regards,

        • 1. Re: Concurrent Requestor - EBS R12
          mdtaylor

          This is by design.  View Requests only shows your requests, and System Administrator, Concurrent, requests allows you to view the requests of others, due the System Administrator function.

          • 2. Re: Concurrent Requestor - EBS R12
            Bommi

            Hi Ayman,

             

            from your login you cannot see the requests that are submitted by other users. But, if you have SYSADMIN logic credentials you can see from there (This credentials will be with your Functional/Admin person and without proper approvals, they will not share you the SYSADMIN credentials with you ).

             

            Or, you can use the below query to find out the Concurrent Programs that are submitted by specific user.

             

            select  fcpt.user_concurrent_program_name,fcr.*

            from    fnd_concurrent_requests fcr

                    ,fnd_concurrent_programs_tl fcpt

                    ,fnd_user fu

            where   1=1

            and     fu.user_name='<USER NAME>'

            and     fcr.requested_by=fu.user_id

            and     fcr.concurrent_program_id=fcpt.concurrent_program_id

            order by fcr.request_id

            ;

             

            Regards,

            Bommi

            1 person found this helpful
            • 3. Re: Concurrent Requestor - EBS R12
              Bommi

              Hi Ayman,

               

              mark my response as helpful or correct if it helped you in anyway.

               

               

              Regards,

              Bommi