What are the steps required to Track WHO Information in our form in Oracle?

Answer 1

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.
8. Table registration will be done only for KFF and DFF columns.
9. For Form development table registrations not required.
   To Show the Module Form Directory Path
10. In PRE‐FORM Trigger change the module name from FND to specific module
    short name (i.e. EX, INC, PPR, etc.,).
11. Save and Compile the form.