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.
- FND_FORM_CUSTOM_RULES
- FND_FORM_CUSTOM_SCOPES
- FND_FORM_CUSTOM_ACTIONS
- FND_FORM_CUSTOM_PARAMS
- FND_FORM_CUSTOM_PROP_VALUES
- 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;