Skip to main content

Hello,

We are using Apps10 in IEE….Is there was a way to tell if the employee had logged in at all under an employee ID?

Thanks,

Jo

Hi @jokasper 

I am afraid I didn’t catch your requirement. Could you define it more precisely?


I’m sorry, I meant, sign in by UserID.  If a UserID is XYZ, is there anyway of looking up to see if XYZ has ever logged into IFS?

 

Thanks,

 

Jo


Hi @jokasper 

yes, it is.

Check this screen.

 


Thank you…. I did check this screen and it looks like it goes back about a short time frame….maybe a day or two.  Can this be controlled somewhere for more history?

 

Jo


Hi @jokasper 

usually it works. You can search by user. Then see the column last call.

Here is the view:

select * from ifsapp.fnd_session_runtime
where status = 'INACTIVE'
and fnd_user not like ' '


Hi,

 

If you use database authentication and are only interested in IEE logins you can check Fnd_User_api.Get_Last_Activity() which gets last_login from table dba_users

 

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

 

BR

Johan


Hi,

 

If you use database authentication and are only interested in IEE logins you can check Fnd_User_api.Get_Last_Activity() which gets last_login from table dba_users

 

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", IFSAPP.Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

 

BR

Johan

 

Hi @JohanLindstrom 

I couldn’t find the table DBA_USERS. It is available in IFS APP 10?


Hi,

 

If you use database authentication and are only interested in IEE logins you can check Fnd_User_api.Get_Last_Activity() which gets last_login from table dba_users

 

select t.IDENTITY "Identity", t.DESCRIPTION "User Name", IFSAPP.Fnd_User_api.Get_Last_Activity(t.IDENTITY) "Last Login"
from FND_USER t
order by t.IDENTITY

 

BR

Johan

 

Hi @JohanLindstrom 

I couldn’t find the table DBA_USERS. It is available in IFS APP 10?

Hi,

 

sys.dba_users is an oracle system view and should be available. Maybe someone else can shed light on why it is or isn’t


BR

Johan


Thank you for your help!  The FND_USER query works for us….thanks again!


Reply