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.
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
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
Following screen will appear. Click on small button appearing against the Block Field
select the $Profiles$ as shown beloe
Now click on small button against Field text box as shown below
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
Following is the List of Commonly used Profiles:
Syntax to use will be following
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.