Showing posts with label tracking data changes. Show all posts
Showing posts with label tracking data changes. Show all posts

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.