Query to find Form Personalization

Query to find Form Personalization
Oracle apps ebs form personalization details

  SELECT DISTINCT
         ffv.form_name,
         user_form_name,
         fcr.function_name,
         fff.user_function_name,
         fcr.description per_description,
         trigger_event,
         trigger_object,
         condition,
         enabled,
         (SELECT user_name
            FROM fnd_user fu
           WHERE fu.user_id = fcr.created_by)
            created_by,
         DECODE (fcr.rule_type,  'F', 'Form',  'A', 'Function')
            personalize_rule_level,
         DECODE (fcs.level_id,
                 10, 'Industry',
                 20, 'Site',
                 30, 'Responsibility',
                 40, 'User')
            context_level,
         DECODE (fcs.level_id,
                 10, '',
                 20, '',
                 30, frt.responsibility_name,
                 40, fu.user_name)
            context_level_value
    FROM fnd_form_custom_rules fcr,
         fnd_form_custom_scopes fcs,
         fnd_form_functions_vl fff,
         fnd_responsibility_tl frt,
         fnd_user             fu,
         fnd_form_vl          ffv
   WHERE     fcs.rule_id = fcr.ID
         AND fcr.function_name = fff.function_name
         AND fcs.level_value = frt.responsibility_id(+)
         AND fcs.level_value = fu.user_id(+)
         AND ffv.form_name = fcr.form_name
ORDER BY form_name

Related posts:

• Register a test concurrent program from backend in Oracle EBS
• Supervisor Hierarchy and Approval Limits in Oracle EBS R12
• Query to find vacation rules in Oracle R12
• View java class source in oracle database
• Load Java source code in oracle database
• Query to find all APIs of Oracle Apps modules
• OAF customizations queries
• Oracle apps list of concurrent programs in a Request Set
• Query to get Organization Hierarchy in Oracle apps
• Oracle apps query to find incompatible programs blocking a concurrent request
• Form function attached to which responsibility and user
• Query to find the responsibility attached to user in oracle apps
• How to enable debug log in Oracle apps EBS
• How to add AME role and responsibility to user
• Oracle form attached to which responsibility
• SQL query to get MIME type for file extension
• Query to get concurrent program and executable details
• Query to get responsibility level profile option values
• Query to validate migration of XML/BI Publisher Template and Data Definition
• Query to get details of XML/BI Publisher Template and Data Definition
• Query to get Site level and Organization level Profile Option Value
• PL-SQL code to reset application user password
• PL-SQL Procedure to send email with attachment
• PL-SQL to delete Concurrent Program and Executable
• Query to get the details of the lock in the database
• PL-SQL code to delete XML/BI Publisher template and Data Definition
• Query to find Form Personalization
• Query to find profile option values
• Query to get details of concurrent program parameters
• PL-SQL Code to find Menu Hierarchy of a responsibility
• Query to find details of Flex value sets
• Query to find concurrent program Responsibility and Request Group
• Concurrent program SQL statement currently running in background
• Query to find scheduled concurrent programs
• Query to kill database session for a concurrent request
• Query to get DFF (Descriptive Flex Field) Details

Upload your own post and refer it anywhere anytime: