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