8 Replies Latest reply on Mar 25, 2016 1:55 PM by happy10319

    is any user connected ?

    happy10319

      Hi ,

      on 11.5.10 on Aix,

      how to know if any user is connected to E-Business ? Or there is no user connected ?

       

      Thank you.

        • 1. Re: is any user connected ?
          Bashar.

          Hi,

           

          If you have the sign-on audit enabled then you can use the Monitor Users form to find out who is using the application.

          You can also check this from the OS by issuing the following command:

           

          ps -ef |grep f60web

           

          Regards,

          Bashar

          • 2. Re: is any user connected ?
            ocol

            Hi,

             

            I use these two queries to get the number of connected users and the details of the related sessions:

             

            --------------------------------------------------------------------------------
            -- Number of connected users  
            --------------------------------------------------------------------------------
            SELECT  'User sessions : '|| COUNT (DISTINCT session_id) how_many_user_sessions
            FROM    icx_sessions icx
            WHERE   disabled_flag != 'Y'
              AND   pseudo_flag = 'N'
              AND  (last_connect + DECODE(fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),
                                          NULL, limit_time,
                                          0, limit_time,
                                          fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60)
                              / 24
                           ) > SYSDATE
            AND counter < limit_connects
            
            
            -- Sessions details
            SELECT  fu.user_name
                   ,frv.responsibility_name
                   ,fffv.user_function_name
                   ,icx.function_type
                   ,icx.session_id
                   ,icx.nls_language
                   ,icx.language_code
                   ,icx.counter
                   ,icx.first_connect
                   ,icx.last_connect
                   ,fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') "Time Out Profile"
            FROM    icx_sessions icx
                   ,fnd_responsibility_vl frv
                   ,fnd_user fu
                   ,fnd_form_functions_vl fffv
            WHERE   1 = 1
              AND   icx.user_id           = fu.user_id
              AND   icx.responsibility_id = frv.responsibility_id
              AND   icx.function_id       = fffv.function_id
              AND   disabled_flag != 'Y'
              AND   pseudo_flag = 'N'
              AND  (last_connect + DECODE(fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),
                                          NULL, limit_time,
                                          0, limit_time,
                                          fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60)
                              / 24
                           ) > SYSDATE
              AND   last_connect > SYSDATE - 10
            ORDER BY icx.last_connect DESC
            
            
            
            
            

             

            Hope this helps.

             

            Cheers,

            Olivier

            • 3. Re: is any user connected ?
              Hussein Sawwan-Oracle

              This was discussed many times in the forums before, see previous threads for details -- https://community.oracle.com/search.jspa?q=users+connected+EBS

               

              How to Count Total Number of Users Connected to ORACLE Application (Doc ID 295206.1)

              What is the Relationship Between the ICX_SESSIONS Table and the FND_LOGINS Table? (Doc ID 358823.1)

              How To Find The IP Address Of The Client Machine From Where A Particular Forms User Is Connected ? (Doc ID 879092.1)

              How to Track IP Address of the Form Session in Oracle application 11i (Doc ID 878931.1)

               

              Thanks,

              Hussein

              • 4. Re: is any user connected ?
                happy10319

                Thank you.

                SELECT  'User sessions : '|| COUNT (DISTINCT session_id) how_many_user_sessions

                FROM    ICX.icx_sessions icx

                WHERE   disabled_flag != 'Y'

                  AND   pseudo_flag = 'N'

                  AND  (last_connect + DECODE(fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),

                                              NULL, limit_time,

                                              0, limit_time,

                                              fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60)

                                  / 24

                               ) > SYSDATE

                AND counter < limit_connects

                                              *

                Error at line 8

                ORA-00904: "FND_PROFILE"."VALUE" :

                 

                Regards.

                • 5. Re: is any user connected ?
                  ocol

                  Try with apps.fnd_profile.value

                  or connect with apps user

                   

                  Regards,

                  Olivier

                  • 6. Re: is any user connected ?
                    happy10319

                    Thank you.

                    How to access to  Monitor Users form in 11.5.10 ?

                     

                    Thank you.

                    • 7. Re: is any user connected ?
                      Bashar.

                      From System Administrator responsibility:

                      Security -> User -> Monitor

                       

                      Regards,

                      Bashar

                      • 8. Re: is any user connected ?
                        happy10319

                        yes, OK , thank you. Your Query works and show 2 sessions :

                        But  Monitor Users shows more :

                         

                         

                        Thanks