Use of Who Columns in Oracle APPS table

Oracle APPS : WHO COLUMNS

WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed.

Steps required to Track WHO Information in our form

  1. ALTER the table by adding WHO columns in the table.
  2. Open TEMPLATE.fmb in form Builder.
  3. Perform all the pre‐requisites to develop a form.
  4. Include all the WHO columns in the Data Block with NULL Canvas.
  5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers
      at Block Level.
  6. Save and Compile the Form.
  7. Perform all the pre‐requisites to register the form

Note: 1. WHO Columns need not register with the table registration option.
          2. Table registration will be done only for KFF and DFF columns.
          3. For Form development table registrations not required.

To Show the Module Form Directory Path
1. In PRE‐FORM Trigger change the module name from FND to specific module
short name (i.e. EX, INC, PPR, etc.,).

2. Save and Compile the form.