Using $PROFILES$ in Value sets in Oracle
When we open a form, some values are pre-loaded in some dynamic variables like Person_id , organization_id, user_id etc.
We can use these values to limit the results.
Let me show you an example...its an easy one.
I will show employee date of birth in a form filed based on its Person id loaded in $PROFILES$.Value
It is same like creating a Table Validated value with a little change in WHERE CLAUSE
See: How to create Table Validated Value set
Lets create a value set.
Press "Edit Information"
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = :$PROFILES$.PER_PERSON_ID ( Automatically passed)
After i attached the value set to a field, Here is the result.
Value Sets in Oracle Apps
Leave a comment for any query.
We can use these values to limit the results.
Let me show you an example...its an easy one.
I will show employee date of birth in a form filed based on its Person id loaded in $PROFILES$.Value
It is same like creating a Table Validated value with a little change in WHERE CLAUSE
See: How to create Table Validated Value set
Lets create a value set.
Press "Edit Information"
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = :$PROFILES$.PER_PERSON_ID ( Automatically passed)
After i attached the value set to a field, Here is the result.
Value Sets in Oracle Apps
Leave a comment for any query.
Excellent job...
ReplyDeleteWhen I am using :$PROFILES$.PER_PERSON_ID, the previous person id that searched for stays in :$PROFILES$.PER_PERSON_ID. It doesn't change.
ReplyDeleteCan you please clarify.
thanks
Thank you soo much
ReplyDeleteThanks for the information.
ReplyDeleteIf you let us know where such profile options are stored in oracle, then it will be an additional help. I tried finding "PER_PERSON_ID" in Profile options form, but couldn't find it.