A day in the life of an Oracle Applications Consultant

Value sets and input values

The configuration for input values is enriched with value sets. Some tests revealed the power and the actual limitations on FP G.

The first value set I created was one with table validation. It worked right away. Also the value set feature to show a description, but to store an id, worked fine. Additional columns with descriptions in the value set definition, although, were not shown in the element entry screen and the BEE screen.

The element entry values API doesn’t check against the value set validation.

More complex value sets (eg: referencing each other via :$FLEX$.

) were not accepted as valid value sets within the input value screen.

Even when not all value set features are operational at the moment at input value level, this functionality is very useful to present the end user an dynamic list of values.

Posted by Thierry Vergult on 08/26 at 06:51 PM
  1. In my Opinion, Value sets in HRMS ,Best practice is Personal Address flexfield, and CCID. recently We use the Oracle API to upload the peoplesoft data into HRMS.

    Posted by Robin  on  09/13  at  10:40 PM
  2. Hi ,
    In 11.0.3 i want to create a lookup from suppliers..For that i want the valueset (Validation Type) Table instead of Only Dependent and Independent…....Tell me how to proceed..


    Posted by .(JavaScript must be enabled to view this email address)  on  04/07  at  07:09 PM
  3. hi friend any one help me. how to meainten the relation between independent and dependent values set using $flex$

    Posted by .(JavaScript must be enabled to view this email address)  on  01/11  at  11:03 PM

Add Comment Information Here

Please note that comments will only be accepted from valid members of this site who provide feedback that is beneficial to readers of the blog. ALL comments (even those from members) will be subject to moderation.


Notify me of follow-up comments?

Submit the word you see below: