ORACLE APPS: LAST_UPDATE_LOGIN column [message #194323] |
Thu, 21 September 2006 09:04 |
rsubramani
Messages: 11 Registered: January 2006
|
Junior Member |
|
|
Hi EveryOne,
I find most of the tables in ORACLE E-business suite, have this column 'Last_update_login'. could somebody tell, from which table the system refers to update this column.
Thanks
Regards
Subramani
|
|
|
Re: ORACLE APPS: LAST_UPDATE_LOGIN column [message #194400 is a reply to message #194323] |
Fri, 22 September 2006 00:18 |
vin_odks
Messages: 153 Registered: July 2006 Location: -
|
Senior Member |
|
|
Hi,
This column stores values from the table FND_LOGINS (login_id).
It stores sign on audit information about who signs on the application and when. Also contains details regarding the user who submitted the concurrent request and number of sessions.
FND_LOGINS has foreign key in FND_USERS (USER_ID)
Regards,
Vinod
|
|
|
Re: ORACLE APPS: LAST_UPDATE_LOGIN column [message #194418 is a reply to message #194400] |
Fri, 22 September 2006 01:38 |
rsubramani
Messages: 11 Registered: January 2006
|
Junior Member |
|
|
Hi,
I did check this table. I created an entry in 'Item Categories' in TAX. I refer to the table and refer the 'Last_update_login' value in the fnd_logins table, but unable to select the value from this table (fnd_logins).
Thanks a lot.
Regards
Subra.
|
|
|
|
|
|