Verifying Form Personalizations

— To verify Personalization Rules
  
SELECT   ffcr.SEQUENCE “Seq”, ffcr.description “Description”,
         DECODE (ffcr.rule_type,
                 ‘F’, ‘Form’,
                 ‘A’, ‘Function’,
                 ‘Other’
                ) “Level”,
         ffcr.enabled “Enabled”, ffcr.trigger_event “Trigger Event”,
         ffcr.trigger_object “Trigger Object”, ffcr.condition “Condition”,
         DECODE (ffcr.fire_in_enter_query,
                 ‘Y’, ‘Both’,
                 ‘N’, ‘Not in Enter-Query Mode’,
                 ‘O’, ‘Only in Enter-Query Mode’,
                 ‘Other’
                ) “Processing Mode”
    FROM apps.fnd_form_custom_rules ffcr
   WHERE ffcr.function_name = ‘ONT_OEXOEORD’
     AND ffcr.form_name = ‘OEXOEORD’
ORDER BY ffcr.SEQUENCE;
  
— To verify Personalization Rules along with Scopes

SELECT   ffcr.SEQUENCE “Seq”, ffcr.description “Description”,
         DECODE (ffcr.rule_type,
                 ‘F’, ‘Form’,
                 ‘A’, ‘Function’,
                 ‘Other’
                ) “Level”,
         ffcr.enabled “Enabled”, ffcr.trigger_event “Trigger Event”,
         ffcr.trigger_object “Trigger Object”, ffcr.condition “Condition”,
         DECODE (ffcr.fire_in_enter_query,
                 ‘Y’, ‘Both’,
                 ‘N’, ‘Not in Enter-Query Mode’,
                 ‘O’, ‘Only in Enter-Query Mode’,
                 ‘Other’
                ) “Processing Mode”,
         DECODE (ffcs.level_id,
                 ’10’, ‘Industry’,
                 ’20’, ‘Site’,
                 ’30’, ‘Responsibility’,
                 ’40’, ‘User’,
                 ‘Other’
                ) “Context Level”,
         ffcs.level_value “Context Value”
    FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_scopes ffcs
   WHERE ffcr.function_name = ‘ONT_OEXOEORD’
     AND ffcr.form_name = ‘OEXOEORD’
     AND ffcr.ID = ffcs.rule_id(+)
ORDER BY ffcr.SEQUENCE, ffcs.level_id;

— To verify Personalization Rules along with Actions

SELECT   ffcr.SEQUENCE “Seq”, ffcr.description “Description”,
         DECODE (ffcr.rule_type,
                 ‘F’, ‘Form’,
                 ‘A’, ‘Function’,
                 ‘Other’
                ) “Level”,
         ffcr.enabled “Enabled”, ffcr.trigger_event “Trigger Event”,
         ffcr.trigger_object “Trigger Object”, ffcr.condition “Condition”,
         DECODE (ffcr.fire_in_enter_query,
                 ‘Y’, ‘Both’,
                 ‘N’, ‘Not in Enter-Query Mode’,
                 ‘O’, ‘Only in Enter-Query Mode’,
                 ‘Other’
                ) “Processing Mode”,
         ffca.SEQUENCE “Action Seq”, ffca.action_type “Action Type”,
         ffca.summary “Action Description”, ffca.LANGUAGE “Action Language”,
         ffca.enabled “Action Enabled”, ffca.property_value,
         ffca.argument_type, ffca.target_object, ffca.object_type,
         ffca.folder_prompt_block, ffca.MESSAGE_TYPE, ffca.MESSAGE_TEXT,
         ffca.builtin_type, ffca.builtin_arguments, ffca.property_name,
         ffca.menu_entry, ffca.menu_label, ffca.menu_seperator,
         ffca.menu_enabled_in, ffca.menu_action, ffca.menu_argument_long,
         ffca.menu_argument_short, ffca.action_id,
         ffca.request_application_id
    FROM apps.fnd_form_custom_rules ffcr, apps.fnd_form_custom_actions ffca
   WHERE ffcr.function_name = ‘ONT_OEXOEORD’
     AND ffcr.form_name = ‘OEXOEORD’
     AND ffcr.ID = ffca.rule_id(+)
ORDER BY ffcr.SEQUENCE, ffca.SEQUENCE;