Question

Web B2E client- Apps 9

  • 26 February 2020
  • 5 replies
  • 213 views

Badge +2

Hi,

We are trying to create a report to get list of users and their last login time using the view ‘ORACLE_ACCOUNT’ and few other views.

We noticed that users who login using webclient(b2e) do not have correct information in this table. Is it because webclient users some common oracle user (e.g ifswebconfig) for the oracle sessoin even though user login with his/her own user?

Thank you

Upekha


5 replies

Userlevel 1
Badge +3

Hi

Yes, Your understanding is correct and ORACLE_ACCOUNT View is not the correct place to get your report to get list of users and their last login time. 

 

You may try IFS Internal table FND_CLIENT_LOGON_TAB table and see whether you have a required details. But as i know when a user is logged on successfully this table gets the details and after log off the particular records get deleted automatically. 

So you may can have your own details from using this table.

 

Thanks

Kosala Sandaruwan

Badge +2

Hi Kosala,

Thank you so much for the quick reply.

I assume ORACLE_ACCOUNT gives correct login information for IEE client and MWO app?

With FND_CLIENT_LOGON_TAB we might have to get a copy of this table frequently to another table if we really need to track data. Anyway even in this table I can’t see web login is tracked.

Thanks & Regards

Upekha

Userlevel 5
Badge +10

Hi Upekha

I just ran a similar test and can see the same issue you have. Also we run auditing on sessions, (dba_audit_session), and this also does not pick up logins from b2e. Interestingly I do not see any other login being used in place of this.

I will keep an eye on this post, to see what others say.

Regards

Mike

Badge +2

Hi Mike,

It’s interesting that b2e login can not even tracked through auditing on sessions.

Thank you for your input.

Regards

Upekha

Userlevel 4
Badge +8

Hi Kosala

I run Fnd_User_api.Get_Last_Activity which gets last_login from table dba_users. It works for me and tracks logins for b2e users aswell. Maybe something to try.

Example:

select IDENTITY "Username",
       DESCRIPTION "Description",
       IFSAPP.Fnd_User_api.Get_Last_Activity(IDENTITY) "Last_Activity"
  from IFSAPP.FND_USER
 order by IDENTITY

BR

Johan

Reply