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.
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;