Oracle EBS LAST_UPDATE_LOGIN来源
ERP中每个表都会有5个列,其中 LAST_UPDATE_LOGIN 来源很多人都不清楚来自哪里
如何查询到?
来自表 fnd_logins
SELECT fu.user_name, fl.*
FROM fnd_logins fl, fnd_user fu
WHERE fl.user_id = fu.user_id
AND fu.user_name = 'LIUYIHE'
;
配置文件:登录:审计层
FND_LOGINS – holds information about users login to system, when and how long.
This table holds one row for each login.
FND_LOGIN_RESPONSIBILITIES – holds information about changes of responsibilities, when and how long being at each responsibility.
For each change this table holds one row with values that identify the user's login session, the user's current responsibility, and when the user is in the responsibility
FND_LOGIN_RESP_FORMS – holds information about using forms, when and how long.
This table holds one row for each form used in the same session with values that identify the user's login session, current responsibility, when and how long using each form.
--刘轶鹤