Query to find profile option values
Oracle apps EBS profile option value query
query to check profile values in oracle apps
How to check profile options in Oracle apps from backend
Query to find profile option values at user and responsibility level
Profile option levels in Oracle Apps R12
query to get system profile values in oracle apps
oracle profile option table
oracle profile option values query
SELECT fa.application_name,
fpov.level_id,
fa.application_short_name,
fpo.USER_PROFILE_OPTION_NAME,
fpo.PROFILE_OPTION_NAME,
DECODE (fpov.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
10006, 'Organization',
10007, 'ServResp',
'Unknown')
Level_name,
DECODE (fpov.LEVEL_ID,
10001, NULL,
10002, fal.APPLICATION_NAME,
10003, frt.RESPONSIBILITY_NAME,
10004, fu.USER_NAME,
10005, svr.node_name,
10006, org.name,
10007, (SELECT n.node_name
FROM fnd_nodes n
WHERE n.node_id = level_value2)
|| '/'
|| (DECODE (fpov.level_value,
-1, 'Default',
(SELECT responsibility_key
FROM fnd_responsibility
WHERE responsibility_id = level_value))),
fpov.level_id)
Level_value,
fpov.PROFILE_OPTION_VALUE
FROM fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
fnd_application_vl fa,
fnd_application_vl fal,
fnd_responsibility_vl frt,
fnd_user fu,
fnd_nodes svr,
hr_operating_units org
WHERE fpo.profile_option_id = fpov.profile_option_id
AND fa.application_id = fpo.application_id
AND fpov.LEVEL_VALUE = fal.APPLICATION_ID(+)
AND fpov.LEVEL_VALUE = frt.RESPONSIBILITY_ID(+)
AND fpov.LEVEL_VALUE = fu.USER_ID(+)
AND fpov.LEVEL_VALUE_APPLICATION_ID = frt.APPLICATION_ID(+)
AND fpov.level_value = svr.node_id(+)
AND fpov.level_value = org.organization_id(+)
AND fpo.USER_PROFILE_OPTION_NAME LIKE
'<profile option name>'
ORDER BY USER_PROFILE_OPTION_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