认识EBS弹性域

• 弹性域

所谓弹性域,就是指在表单中开放更多的字段供用户输入.

说明性弹性域: 只能作为统计分析,出报表使用,不参与系统业务流程的构建,系统(应用程序)也不对之在表单之间作跟踪,追溯.字段为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   anda.id_flex_code =b.id_flex_code

   and b.application_id =c.application_id    andb.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     andc.id_flex_code =e.id_flex_code

order by d.flex_value_set_name,a.id_flex_name,e.id_flex_structure_name