Fnd User Last Date Login

Mar 09, 2016 · Query to find last login date for a user/responsibility Posted by PamNL in Pam Blog on Mar 9, 2016 6:13:00 PM The following query may help to find users that haven't logged in for a long time or which responsibilities are actually used in the system.

Aug 28, 2017 · User's last login and number of current EBS connections - To answer who is logged in EBS R12.1, Oracle DocID 269799.1 says: You can run the Active Users Data Collection Test diagnostic script to get information about all active users currently logged into EBS.

Last Updated By = FND_USER.USER_ID of the user who was logged on when the change was made. Last Update Login = FND_LOGINS.LOGIN_ID of the session which made the changes. Note that the data in FND_LOGINS will probably be purged (we only appear to …

Apr 04, 2011 · Looking through the applsys.fnd_user table on our R12.1.1 EBS system, I see that the last_logon_date field on the table often has lots of entries where the …

Hi, Can any one help in finding in what scenario the last login date for 'Guest' user account will update in fnd_user table. Ran Sign on audit user report but couldn't able to find the session.

Jan 29, 2019 · In order to report on the logged in user history, we need to schedule "Importing User Login History" process to be run daily which updates the security tables in Fusion (ASE_USER_LOGIN_INFO) with the User login details from "FND_SESSIONS" table which stores the user information for 7 days before it gets purged automatically.

Find E-Business Suite users daily logins at the forms Last update (2008-06-09 21:52:44) Date added (2008-02-18 12:35:26)

I used to be able to get this data in 10.7, but with the 11i data model changes, I cannot seem to locate the correct table/view. Bottom line: Which table/view houses a person's last access date FOR EACH RESPONSIBILITY? I won't bore you with the queries I've tried, because it just seems to confuse things and I would like this thread to be free of...

Who column: indicates the user who last updated the row. CREATION_DATE: TIMESTAMP: Yes: Who column: indicates the date and time of the creation of the row. CREATED_BY: VARCHAR2: 64: Yes: Who column: indicates the user who created the row. LAST_UPDATE_LOGIN: VARCHAR2: 32: Who column: indicates the session login associated to the user who last ...

Sep 18, 2012 · FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when ever DML operations are performed from the application. You represent each of the WHO columns as hidden fields in each block of your form (corresponding to the WHO columns in each underlying table).