Flexfield Value Sets with Pair Validation

Posted by: Edi Yanto on: April 30, 2014

• In: Oracle
• 9 Comments

We can have a concurrent program parameter that will be filled with a Key Flexfield value or a range of flexfield values. Oracle EBS has a nice functionality that gives you pop-ups, a validation over the resulting combination and if needed the ID-value for the flexfield combination.

Now, we focus on create the range of account segment using user exits “POPIDR” and “VALIDR“. The R-version of the user-exits automatically create a range. We need 2 parameters to set the range. However, we need only one validation set.

Create value set “EY_LEDGER_FLEXFIELD”


“Edit” event will be triggered when the user enters the cursor into the field with this value set.
“Validation” event will be triggered when the user navigates out of the field, or submits the entire combination.

Now when we set this value set as a parameter for our concurrent program, we can see how the validation works:

Then we add a DISPLAY=”X” to the “Edit” and “Validate” user exits and TITLE to the “Edit” user exits. The “DISPLAY” parameter is defaulting to ‘ALL’. But we can also specify separate segments by their sequence number or names. In our case, we display the 3 segments (segment2, segment4 and segment6)

Now when we run the concurrent program, we get a pop-up for only the 3 values:

Tags: flexfield, oracle ebs, pair validation, popidr, validation, validr, value sets