Step 1:
Navigate to System AdministratoràApplicationàvalidationàset to create a new value set name called "TEST_DFF"
Step 2:
Navigate to System
AdministratoràApplicationàFlexfieldàDescriptiveàSegments
Uncheck Freeze Flexfield Definition to add value set name
under Context Filed values and title is
Flexfield Segment values
Under segments add DFF fields(Attribute1,Attribute2,Attribute3)
Note : if we want we can add upto 50 Attributes
Check Freeze Flexfield Definition and then compile the flex
field definition
Check the DFF fields under the below navigation
Navigate to System AdministratoràApplicationàvalidationàvalues
DFF fields will come under values,Effective as shown below:
Get the values from database.
SELECT ffv.flex_value, attribute1 AS "Host Name", attribute2 AS "User Name",
attribute3 AS "Password"
FROM apps.fnd_flex_value_sets ffvs, apps.fnd_flex_values ffv
WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id
AND ffv.enabled_flag = 'Y'
AND ffvs.flex_value_set_name = 'TEST_DFF'
No comments:
Post a Comment