2 Replies Latest reply on May 6, 2016 12:34 PM by happy10319

    Login name

    happy10319

      Hi,

      on 11.5.10 on AIX ,

      DB 11.2.0

      I use the following query:

      select start_time ,END_TIME, login_name,login_id,login_type from apps.fnd_logins

       

         where

       

        start_time between to_date('04-MAI-2016 9:30:00')

       

         and to_date('04-MAI-2016 10:50:00') order by start_time;

      My questions :

      -Why LOGIN_NAME is empty ?

      -Can I find user login or user name by the displayed LOGIN_ID ? How ?

       

      Thank you.

        • 1. Re: Login name
          Oct Rex

          Hi,

           

          You can get user name from table FND_USER table, USER_NAME column.

          Join tables using USER_ID column.

           

          Hope this helps.

           

          Octavio

          • 2. Re: Login name
            happy10319

            Thank you.

            here is my new query :

            alter session set nls_date_format = 'dd-mon-yyyy hh24:mi:ss';

            select u.user_name,start_time ,END_TIME, login_name,login_id,login_type from apps.fnd_logins ,fnd_user u

               where

               start_time between to_date('04-MAI-2016 9:30:00')

                                     and to_date('04-MAI-2016 10:50:00')

                                     and apps.fnd_logins.user_id=u.user_id

                                     order by start_time;