Oracle EBS R12 - Enable WHO Columns / Enable Record History

Tracking Data Changes with Record History (WHO)

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

Steps
1. Add the who columns to the your form (if not available)

Alter table XX_TABLENAME
Add (LAST_UPDATE_DATE      DATE          NOT NULL,
     ACCOUNT_NUMBER        VARCHAR2(30)  NOT NULL,
     LAST_UPDATED_BY       NUMBER(15)    NOT NULL,
     CREATION_DATE         DATE          NOT NULL,
     CREATED_BY            NUMBER(15)    NOT NULL,
     LAST_UPDATE_LOGIN     NUMBER(15));

2. select pre-insert and pre-update and add following code;
FND_STANDARD.SET_WHO;

3.change the property class
Apply the CREATION_OR_LAST_UPDATE_DATE property class to the form fields
CREATION_DATE and LAST_UPDATE_DATE. This property classes sets the correct
attributes for these fields, including the data type and width