Wednesday, May 8, 2013

Enabling DFF with the value set

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

Step 3:

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

Price List Query for Item

 SELECT qph.list_header_id,        qph.name,        qph.description,        qphh.start_date_active,        qphh.currency_code,        q...