Standard WHO Columns

The following are the Standard WHO Columns in most of the Oracle tables:

1. created_by
2. creation_date
3. last_update_date
4. last_updated_by
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.