Thangs

• May 20th, 2005

 

Columns tracking the audit trial(user) information. 
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN

Sreenivas

• Sep 29th, 2005

 

You can use FND_STANDARD.SET_WHO API to set who columns.

jency

• Nov 27th, 2007

 

Hi,

I wanted to enter the details of the user in the who columns.

I saw the answer for this questions as use FND_STANDARD.SET_WHO.

Can some one explain in detail, how to use that.

Thanks,
Jency

sajasand

 Profile Answers by sajasand 

• May 5th, 2009

 

You can use the App_standard.Set_Who Function in pre_insert trigger and pre_update at the form level it will capture the details and update it in database table

rajusrnk

 Profile Answers by rajusrnk Questions by rajusrnk

• Apr 1st, 2011

 

to activate the who columns for a form u need to do following.
1)u have to call an following API in PRE_INSERT and PRE_UPDATE
fnd_standard.set_who();
2) relogin

monte

• Aug 23rd, 2011

 

Its actually not at the Form level, It should be at the Block Level. And function is Fnd_Standard.Set_who

bharath

• Jan 31st, 2012

 

WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed.
1) Created by
2) Creation date
3) Last _updated_by
4) last_update_date
5) last_update_login
Use fnd_profile.VALUE (‘USER_ID’) for retrieving the user_id which will be used by created_by column.

Creation date and last_update_date will be normally SYSDATE.

last_updated_by is same as created_by.

Use USERENV (‘SESSIONID’) for getting the last_update_login id.

Lokanath Reddy

• Apr 27th, 2017

 

How to get last_update_login?