Who columns in a table allows users to track changes made to the data in Oracle Apps. It also helps to differentiate between changes made by forms and changes made by concurrent programs.
Below is the list of standard who columns,
CREATED_BY
The created_by is a number(15) not null column in a table that keeps track of user-created each row. It Maps to user_id columns from the fnd_user table.
CREATION_DATE
The CREATION_DATE is a date not a null column in a table that stores the date on which each row was created. Use the SYSDATE function to assigned value to this field.
Note: –
created_by and creation_date columns, you should use only in the insert statement and not in the update.
LAST_UPDATED_BY
The last_updated_by is a number(15) not null column in a table that keeps track of who last updated row. It Maps to user_id columns from the fnd_user table.
LAST_UPDATE_ DATE
The LAST_UPDATE_ DATE is a date not a null column in a table that stores the date on which each row was updated. Use the SYSDATE function to assigned value to this field.
LAST_UPDATE_ LOGIN
Provides access to information about the operating system login of the user who last updated each row