Example of Special Validation for a Single Segment
Here is an example of how to use Special validation when you want to let your users pass a single Accounting Flexfield segment value as a parameter to a report. To let your user choose a single segment, you must provide a key flexfield window from within the report parameters window on the Run Reports form. Since you want to pass an existing segment value and this is a foreign key flexfield, you use VALIDATE=PARTIAL. You do not use the DATA_FIELD=:!ID or ID=:!ID argument in this case because you do not use hidden ID value sets with the Accounting Flexfield. You do not use a Load event because you are not using :!ID. This example uses structure 101 of the Accounting Flexfield (though normally you might get your structure number from a prior segment or a profile option, depending on how you use your value set), and the flexfield qualifier FA_COST_CTR identifies which segment it passes. You define your Events and Functions in this field as follows.
For data entry validation (Event = Edit), you would enter:
FND POPID
APPL_SHORT_NAME=SQLGL
CODE="GL#"
NUM=101
REQUIRED=N
VALIDATE=PARTIAL
DISPLAY="FA_COST_CTR"
SEG=:!VALUE
DESC=:!MEANING
NAVIGATE=!DIR
DINSERT=N
For data validation (Event = Validate), you would enter:
FND VALID
APPL_SHORT_NAME=SQLGL
CODE="GL#"
NUM=101
REQUIRED=N
VALIDATE=PARTIAL
DISPLAY="FA_COST_CTR"
SEG=:!VALUE
DESC=:!MEANING
DINSERT=N
