top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
269 views
What are the steps required to Track WHO Information in our form in Oracle?
posted Nov 24, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer
  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.
answer Nov 25, 2015 by Arun Gowda
...