Insert Who Columns in Oracle Apps R12 Table

Standard WHO Columns

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

1. created_by -> Keeps track of which user created the record(row) : FND_PROFILE.VALUE('USER_ID')
2. creation_date -> Stores the date on which a row was created : SYSDATE
3. last_update_by ->  Keeps track of who last updated the row : FND_PROFILE.VALUE('USER_ID')
4. last_update_date -> Stores the date on which the row was last updated : SYSDATE
5. last_update_login -> Login Session ID of the user : USERENV('SESSIONID')