The below Forms Personalization query will list all the forms in Oracle Applications that have been customized using Forms Personlization:
1 2 3 4 5 6 7 8 9 10 |
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
1 2 |
select * from Fnd_Form_Custom_Actions ca where rule_id = 127; |
Navigation: Help > Diagnostics > Custom Code > Personalize
Read more forms personalization articles http://erpschools.com/articles/forms-personalization-tutorial http://erpschools.com/articles/change-displayed-data-in-lov-using-forms-personalization http://erpschools.com/articles/tools/forms/personalization/forms-personalization-call-plsql-procedure