Example of Using Profile Values in Value Sets

By | May 21, 2015

In my previous article i shared the steps to use profile values in Forms Personalization. In this article of Oracle HRMS Overview, i shall share the steps for using profile values in value sets.

Syntax to Use Profile Values in Value Sets

Following Diagram shows the syntax to use the profiles values within the value set.

Profile Values

If you do not remember the syntax or want to see other value sets where clause, through following query you can find the where clause for other value sets

select Additional_where_Clause
from FND_FLEX_VALIDATION_TABLES
where  Additional_where_Clause is not null

How to Find out other possible profile values

Click on the Examine following the navigation shown in the diagram below

Profile Values 1

Following screen will appear. Click on small button appearing against the Block Field

Oracle HRMS

select the $Profiles$ as shown beloe

Profile Values in Oracle HRMS

Now click on small button against Field text box as shown below

Oracle Apps Profile Values

It will display big list of values. All these values are set by Oracle Apps environment at run time. We can use these values pragmatically in our logic

Profiles in Oracle Apps

 

Following is the List of Commonly used Profiles:

PER_BUSINESS_GROUP_ID
PER_SECURITY_PROFILE_ID
RESP_APPL_ID
RESP_NAME
RESP_ID
ORG_ID
PROG_APPL_ID

Syntax to use will be following

:$PROFILES$.PER_BUSINESS_GROUP_ID
:$PROFILES$.PER_SECURITY_PROFILE_ID
:$PROFILES$.RESP_APPL_ID
:$PROFILES$.RESP_NAME
:$PROFILES$.RESP_ID
:$PROFILES$.ORG_ID
:$PROFILES$.PROG_APPL_ID

Alternate Way to use Profiles is given in this article.

If you have liked contents in this post and you think it can be helpful to others, please share it at least once in your circle, in this way, you will join me in my cause to Learn Share and Grow. Come on, Lets Grow Together.

Related Articles

List of Ready Made Solutions for Beginners
Profile Values in Forms Personalization
Apps Interview Questions
Free Online Assessment
10 Steps for XML Bursting in Oracle Apps