Intro:-This script will provide all related Form Personalization details.
Code:-
SELECT ffv.form_id “Form ID”,
ffv.form_name “Form Name”,
ffv.user_form_name “User Form Name”,
ffv.description “Form Description”,
ffcr.sequence “Sequence”,
ffcr.description “Personalization Rule Name”
FROM fnd_form_vl ffv,
fnd_form_custom_rules ffcr
WHERE ffv.form_name = ffcr.form_name
ORDER BY ffv.form_name, ffcr.sequence;
Test results:-
| Form Id | Form Name | User Form Name | Form Description | Sequence | Personalization Rule Name |
| 10001 | FNDSCAUS | Define Application Setup | Application Screen | 10 | User PWD Expiration |
| 10009 | PERWSH | PO indicator | Indicator Details | 10 | PO Status |
Recent Posts
