Home » Applications » Oracle Fusion Apps & E-Business Suite » ORACLE APPS: LAST_UPDATE_LOGIN column
ORACLE APPS: LAST_UPDATE_LOGIN column [message #194323] Thu, 21 September 2006 09:04 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: ORACLE APPS: LAST_UPDATE_LOGIN column [message #194421 is a reply to message #194323] Fri, 22 September 2006 02:03 Go to previous messageGo to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
hi,

Use FND_GLOBAL.login_id.

Regards
Vinod
Re: ORACLE APPS: LAST_UPDATE_LOGIN column [message #194769 is a reply to message #194400] Mon, 25 September 2006 04:03 Go to previous messageGo to next message
rsubramani
Messages: 11
Registered: January 2006
Junior Member
Hi Vinod,

FND_GLOBAL is a package body. How I can use this to find the 'LAST_UPDATE_LOGIN'

Thanks

Regards
Subramani
Re: ORACLE APPS: LAST_UPDATE_LOGIN column [message #194787 is a reply to message #194323] Mon, 25 September 2006 05:36 Go to previous message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Hi,

Inside your procedure

FND_GLOBAL.INITIALLIZE;
last_update_login:=FND_GLOBAL.LOGIN_ID;

Insert this value for the last_update_login

Regards
Vinod


Previous Topic: Doubt in Multi-Org while creating business group
Next Topic: Business group vs organization Units
Goto Forum:
  


Current Time: Sat Dec 10 10:59:58 CST 2016

Total time taken to generate the page: 0.07181 seconds