Question

User sign-on log?

  • 6 November 2022
  • 9 replies
  • 106 views
J
Rank
Userlevel 3
Badge +7

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

9 replies

Link
Rank
Userlevel 7
Badge +22

Hi @jokasper 

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

Kind regards
J
Rank
Userlevel 3
Badge +7

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

Link
Rank
Userlevel 7
Badge +22

Hi @jokasper 

yes, it is.

Check this screen.

 

Kind regards
J
Rank
Userlevel 3
Badge +7

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

Link
Rank
Userlevel 7
Badge +22

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 ' '

Kind regards
J
Rank
Userlevel 4
Badge +8

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

Link
Rank
Userlevel 7
Badge +22

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?

Kind regards
J
Rank
Userlevel 4
Badge +8

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

J
Rank
Userlevel 3
Badge +7

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

Reply


Terms & ConditionsCookie settings