WHO COLUMNS in Oracle Apps

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 aTable when a DML operation s (i.e. INSERT, UPDATE) performed.1) Created by2) Creation date3) Last _updated_by4) last_update_date5) 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