Form Personalization Tables in Oracle Apps R12 - Orapoint

We use Form Personalization function to change the actions of Forms-based screens declaratively, such as modifying assets, running builtins, showing notifications, and inserting menu entries.

An Event is a trigger point in a form, such as when the form starts up (WHEN-NEW-FORM-INSTANCE) or when the emphasis shifts to a new record (WHEN-NEW-RECORD-FOCUS) (WHEN-NEW-RECORD-INSTANCE). Almost every form sends regular events, and some forms send additional product-specific events.

Form Personalization Table List in Oracle Apps R12

The tables that are filled when any Forms Personalization is done are listed below.

1. FND_FORM_CUSTOM_RULES
2. FND_FORM_CUSTOM_SCOPES
3. FND_FORM_CUSTOM_ACTIONS
4. FND_FORM_CUSTOM_PARAMS
5. FND_FORM_CUSTOM_PROP_VALUES
6. FND_FORM_CUSTOM_PROP_LIST

Form Personalization Query

The Forms Personalization query below will return a list of all Oracle Applications forms that have been personalised using Forms Personlization:

SELECT distinct 
      ffcr.form_name , 
      ffcr.enabled, 
      fft.USER_FORM_NAME, 
      fat.APPLICATION_NAME , 
      ffcr.description, 
      ffcr.id RULE_ID
FROM  FND_FORM_CUSTOM_RULES ffcr,
      FND_FORM ff,
      FND_FORM_TL fft,
      fnd_application_tl fat
WHERE enabled = 'Y'
  and ffcr.form_name = ff.form_name
  and ff.form_id = fft.form_id
  and ff.application_id = fat.application_id
order by application_name;