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.

Using $PROFILES$ in Value sets in Oracle

Press "Edit Information"


Using $PROFILES$ in Value sets in Oracle




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.

Using $PROFILES$ in Value sets in Oracle

Value Sets in Oracle Apps

Leave a comment for any query.

4 comments:

  1. When I am using :$PROFILES$.PER_PERSON_ID, the previous person id that searched for stays in :$PROFILES$.PER_PERSON_ID. It doesn't change.

    Can you please clarify.

    thanks

    ReplyDelete
  2. Thanks for the information.
    If 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.

    ReplyDelete