弹性域
所谓弹性域,就是指在表单中开放更多的字段供用户输入.
说明性弹性域: 只能作为统计分析,出报表使用,不参与系统业务流程的构建,系统(应用程序)也不对之在表单之间作跟踪,追溯.字段为attribute.
键弹性域:  参与业务流程构建,系统的应用程序需要对之进行跟踪,追溯.在整个EBS中总数不过35个.字段为segment.
当表单中白色[ ]方框锁定为灰色,无法输入时,可以在此取消冻结:developer->FlexField->Key->Register.(说明性弹性域)
增加表单中说明性弹性域的字段:developer->FlexField->Descriptive->segments
增加表单中键弹性域字段:developer->FlexField->Key->segments
有时需要指定表单中某个attribute固定对应其它表中的某个字段的值.这属于表单的个性化设置.
Help->diagnostics->Customer code->personalize
如何查找FORM中某个flexfield:
      点菜单HELP-->Diagonstics-->Examine,进入会显示这个ITEM在FORM中的BLOCL和FIELD 记下，然后，在BLOCL中输入：$DESCRIPTIVE_FLEXFIELD$， FIELD 中输入刚才记下的BLOCL。FIELD　在value 中的就是弹性域的标题如何查找form里的某个flexfield如何查找form里的某个flexfield如何查找form里的某个flexfield如何查找form里的某个flexfield
Value Set Usage by Descriptive Flexfields
select  flex_value_set_name "Value Set",
               descriptive_flexfield_name "Flexfield",
               descriptive_flex_context_code "Structure",
               end_user_column_name "Column"
      from apps.fnd_descr_flex_column_usages a,
               apps.fnd_flex_value_sets b
    where a.flex_value_set_id = b.flex_value_set_id
        and descriptive_flexfield_name not like '$SRS$%'
order by flex_value_set_name,
                descriptive_flexfield_name,
                descriptive_flex_context_code;
Value Set Usage by Key Flexfields
select   d.flex_value_set_name "Value Set",    a.id_flex_name "Flexfield",
            e.id_flex_structure_name "Structure", c.segment_name "Segment"
from   apps.fnd_id_flexs a,                    apps.fnd_id_flex_structures b,
             apps.fnd_id_flex_segments c,   apps.fnd_flex_value_sets d,
             apps.fnd_id_flex_structures_tl e
where a.application_id = b.application_id    and a.id_flex_code = b.id_flex_code
   and b.application_id = c.application_id     and b.id_flex_code = c.id_flex_code
   and b.id_flex_num = c.id_flex_num
   and c.flex_value_set_id = d.flex_value_set_id
   and c.application_id = e.application_id      and c.id_flex_code = e.id_flex_code
order by d.flex_value_set_name, a.id_flex_name, e.id_flex_structure_name