Forms Personalization query

The below Forms Personalization query will list all the forms in Oracle Applications that have been customized 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;

–Get Customer actions for a specific rule

select * from Fnd_Form_Custom_Actions ca

where rule_id = 127;

Navigation: Help > Diagnostics > Custom Code > Personalize