HOW TO reference profile values from value setsThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 26-Oct-2005 Keywords: HOWTO, VALUESET, VALUE SET, PROFILE

Goal
To reference a profile value from a value set

Facts


Solution
In the WHERE clause of the table validated value set, reference the profile option using the following syntax:

AND organization_id =:$PROFILES$.MFG_ORGANIZATION_ID

Note that the:$PROFILES$ has an 'S' on the end of PROFILE. Also, note that the profile option referenced is the underlying profile name NOT the user profile name.




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

2 words added
1 word deleted

view changes
- complete history)
Keyword tags: HOW TO PROFILES VALUE SETS
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 simulate DISTINCT or GROUP BY in a value set HOW TO find all profile option values
HOW TO find DFFs that use a particular value set 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