SQL Script for Form Personalisation in Oracle Apps R12

SQL Script for Form Personalisation in Oracle Apps R12

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

-- To verify Personalization Rules along with Scopes

--#########################################################    

     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 1 = 1

     --AND ffcr.function_name = 'ONT_OEXOEORD'

      AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffcs.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffcs.level_id;

SELECT   ffcr.SEQUENCE "Seq", ffcr.description "Description",

--#########################################################

 -- To verify Personalization Rules along with Actions

--#########################################################       

 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 1 = 1

    --and ffcr.function_name = 'ONT_OEXOEORD'

 AND ffcr.form_name = 'ARXRWMAI'

      AND ffcr.ID = ffca.rule_id(+)

      AND  ffcr.SEQUENCE IN('20','25')

 ORDER BY ffcr.SEQUENCE, ffca.SEQUENCE;