HOW TO find all profile option valuesThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 03-Nov-2005 Keywords: HOWTO, PROFILES, PROFILE OPTIONS

Goal
Find the various values at user, responsibility and site level for a particular profile option.

Facts


Solution
Run the following sql script:

SELECT
fpo.user_profile_option_name
,fpo.profile_option_name
,site.profile_option_value site_val
,r.responsibility_name resp_name
,resp.profile_option_value resp_val
,fu.user_name
,usr.profile_option_value user_val
FROM fnd_profile_options_vl fpo
,fnd_profile_option_values site
,fnd_profile_option_values resp
,fnd_responsibility_vl r
,fnd_profile_option_values usr
,fnd_user fu
WHERE 1=1
AND UPPER( fpo.user_profile_option_name) LIKE '&profile_name'
AND site.profile_option_id(+) = fpo.profile_option_id
AND site.level_id(+) = 10001
AND resp.profile_option_id(+) = fpo.profile_option_id
AND r.responsibility_id (+) = resp.level_value
AND resp.level_id(+) = 10003
AND usr.profile_option_id(+) = fpo.profile_option_id
AND usr.level_id(+) = 10004
AND fu.user_id(+) = usr.level_value
ORDER BY 1
/




consultium
consultium 		Latest page update: made by consultium , Oct 6 2009, 12:43 PM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: HOW TO PROFILE OPTIONS PROFILES
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
HOW TO programmatically launching concurrent request sets HOW TO find DFFs that use a particular value set HOW TO reference profile values from value sets
HOW TO trace a concurrent program HOW TO make flexfield fields dependent on another HOW TO use personalize for simple customizations
HOW TO setup a printer driver SQL Dev SDK How Tos