3 Replies Latest reply on Nov 11, 2019 6:28 AM by 966638

    Query to find the users

    966638

      Hi,

       

      I want to get the list of users who accessed application modules for a period of month.

       

      How I can get and please provide script

       

      eg: Applications modules: HRMS, General Ledger

       

       

      Thanks

        • 1. Re: Query to find the users
          yoonas

          Hi,

           

          On OAM there is a way under application usage reports. See if that helps

           

           

           

          Regards,

          Yoonas

          • 2. Re: Query to find the users
            Bharat -Oracle

            Hi

             

            You can get that information from icx_sessions table

             

            select  f.user_name ,to_char(i.creation_date,'DD-MON-YY HH:MI:SS'), 

            i.*

            from icx_sessions i, fnd_user f

            where i.user_id = f.user_id

            and i.creation_date between sysdate-30 and sysdate;

             

            You can change the where clause or remove columns.

            This query will show you same user multiple times because this table captures each login and change of responsiiblity.

            So you can filter as per your requirement.

             

            Best Regards

            Bharat

             

            ****If any response assisted you on this matter, please feel free to click on the Correct Answer and/or helpful button, in order to assist the community and its users. System will credit extra points to you as well***

            • 3. Re: Query to find the users
              966638

              Thanks a lot for this avigation.