ORACLE EBS LAST_UPDATE_LOGIN

ab168

　　LAST_UPDATE_LOGIN 是指当前登录用户的login_id。

　　EBS会记录每个用户的登录登陆时间，结束时间，PID,SPID，登录方式等等，用这个字段来记录对当前表进行操作的用户的登录信息。
　　

• select * from fnd_logins;
  
• 
  
• gl_last_update_login := fnd_global.login_id;
  
• gl_user_id := fnd_global.user_id;
  

　　

　　form中可使用：FND_PROFILE.VALUE('LOGIN_ID');
　　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 have two weeks data) and so you will  only be able to
　　
find the details of the most recent logins still in the  table.

　　
Let's assume you have a user called FRED (say User>　　

　　
When user FRED logs on to Oracle Applications a record is created

　　
in  the FND_LOGINS table (say Login>　　
a change is  made to a Project record (PA_PROJECTS_ALL table) -
　　
the Last Updated By will  be set to 123 and the Last Update Login
　　
will be set to 4321.
　　

　　
If FRED  logs off and then logs on again, another record is

　　
created in the FND_LOGINS  table (say Login>　　
logged in this time, another change is  made to the Project
　　
record - the Last Updated By will still be 123 and the  Last
　　
Update Login will be updated to 5432.