Tracking Data Changes with Record History WHO columns

The Record History (WHO) feature reports information about who created or updated rows in Oracle Applications tables. Oracle Applications upgrade technology relies on Record History (WHO) information to detect and preserve customizations.

If you add special WHO columns to your tables and WHO logic to your forms and stored procedures, your users can track changes made to their data. By looking at WHO columns, users can differentiate between changes made by forms and changes made by concurrent programs.

You represent each of the WHO columns as hidden fields in each block of your form

(Corresponding to the WHO columns in each underlying table). Call

FND_STANDARD.SET_WHO in PRE-UPDATE and PRE-INSERT to populate these fields.

WHO Columns in Oracle Apps

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

Usually while populating WHO columns, following values have to be used

Creation_date = SYSDATE

Created_by = fnd_profile.VALUE ('USER_ID')

Last_update_date = SYSDATE

Last_updated_by = fnd_profile.VALUE ('USER_ID')

Last_update_login = fnd_global.login_id

Request_id = fnd_global.conc_request_id