Working With Pair Value Set
Pair Value Set
i. “flexfield within another flexfield” or “valueset within valueset”
ii. it allows user to enter a combination of values , with a delimiter
iii. it is dependent on the key flexfield defined in Oracle Applications
iv. it is used for entering combination of values in key flexfield(s)
How Pair value set looks:
Pair Value Set Popup Window.
In the above diagram the Part Number field consist of three segments:
Category
Item
Color
A combination of these values is one part number.
Pair Value Set Example (Williams Energy):
Name of the Value Set: XXAD_ACCT_FLEXFIELD
Purpose: This value set is created for determining the account parameter for Cost Center report consisting of the following segments:
Company
Operating Unit
Cost Center
FERC Account
A diagram for the above explanation
The above value set is derived from the accounting flexfield and it displays the first 4 segments of the accounting flexfield out of 10 segments.
A diagram of the Accounting key flexfield on which this valueset is based upon.
In order to create such pair value set titled as “XXAD_ACCT_FLEXFIELD”.
The GL_SRS_LEDGER_FLEXFIELD value set is used as standard.
The following changes are made in Edit Event & Validate Event:
Clause NUM=:$FLEX$.GL_SRS_COA_ID_BYSOB is removed
Purpose: The above clause is used to display account segments in the flexfield window based on the CHART_OF_ACCOUNTS_ID. Since the report does not display or use CHART_OF_ACCOUNTS_ID, so this clause is removed.
New clause DISPLAY is added after REQUIRED clause.
Purpose: This clause is used to display those segments which are relevant or requested by the user. This clause use segment number as parameter.
For example if the user want to see the first and the third segment, the syntax is: DISPLAY=”1” DISPLAY=”3”
Special Validation Routines for Value Set
Event: Edit (Calls special validation routine when the user cursor enter the segments of the value set)
FND POPIDR APPL_SHORT_NAME="SQLGL" CODE="GL#"
REQUIRED="Y"
DISPLAY="1"
DISPLAY="2"
DISPLAY="3"
DISPLAY="4"
VALIDATE="NONE" SEG=":!VALUE" DESC=":!MEANING"
NAVIGATE="!DIR"
Event: Validate (Calls special validation routine when the user cursor leaves the segments of the value set or closes the popup window)
FND VALIDR APPL_SHORT_NAME="SQLGL" CODE="GL#"
VALIDATE="NONE"
REQUIRED="Y"
DISPLAY="1"
DISPLAY="2"
DISPLAY="3"
DISPLAY="4"
DESC=":!MEANING" SEG=":!VALUE"
POPIDR and VALIDR are calling sequence for range key flexfields for displaying and validating values.
APPL_SHORT_NAME = <short name of the application with which the flexfield is registered>
CODE= <code that is used to setup the key flexfield using the Register Key Flexfield window>
VALIDATE= <used to validate the values of flexfield segments > NONE (no validation, defaulted for range flexfield) , PARTIAL (validate each individual segment when a user enters)
REQUIRED = <Specify whether the flexfield segment is mandatory or optional>
DISPLAY = < used to display specific flexfield segment(s) based on segment number>
DESC = <non database , non editable field used to display the concatenated description segment values>
SEG = < used to contain the concatenated segment values plus the delimiter used in key flexfield>
***For further reference refer to the flexfield user guide
Page 1 of 3
Post a Comment