Skip to content
Home ยป Who Columns in Oracle Apps

Who Columns in Oracle Apps

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