Example of Pair Validation
Here is an example of how to use Pair validation. Suppose you want to let your users pass a range of concatenated Accounting Flexfield segments as parameters to a report. For example, you want to let your users request a report on all combinations where the second segment value is between 001 and 101, inclusive. To let your user choose such a range, you must provide a key flexfield range window from within the report parameters window on the Run Reports form. To do this, you simply define a value set with Pair validation and use your familiar range flexfield user exits to pass a range of concatenated segment values. For a range flexfield, you use VALIDATE=PARTIAL (or NONE). Since you use a range flexfield, you cannot use the ID=:!ID argument. You do not use DATA_FIELD=:!ID in this example (hidden ID value sets are not allowed with the Accounting Flexfield), so you do not need a Load event. This example uses structure 101 of the Accounting Flexfield. You define your Events and Functions in this field as follows:
For data entry validation (Event = Edit), you would enter:
FND POPIDR
APPL_SHORT_NAME=SQLGL
CODE="GL#"
NUM=101
VALIDATE=PARTIAL
SEG=:!VALUE
DESC=:!MEANING
NAVIGATE=!DIR
For data validation (Event = Validate), you would enter:
FND VALIDR
APPL_SHORT_NAME=SQLGL
CODE="GL#"
NUM=101
VALIDATE=PARTIAL
SEG=:!VALUE
DESC=:!MEANING