所谓弹性域,就是指在表单中开放更多的字段供用户输入.
说明性弹性域: 只能作为统计分析,出报表使用,不参与系统业务流程的构建,系统(应用程序)也不对之在表单之间作跟踪,追溯.字段为attribute.
键弹性域:? 参与业务流程构建,系统的应用程序需要对之进行跟踪,追溯.在整个EBS中总数不过35个.字段为segment.
当表单中白色[ ]方框锁定为灰色,无法输入时,可以在此取消冻结:developer->FlexField->Key->Register.(说明性弹性域)
增加表单中说明性弹性域的字段:developer->FlexField->Descriptive->segments
增加表单中键弹性域字段:developer->FlexField->Key->segments
- 有时需要指定表单中某个attribute固定对应其它表中的某个字段的值.这属于表单的个性化设置.
Help->diagnostics->Customer code->personalize
??????点菜单HELP-->Diagonstics-->Examine,进入会显示这个ITEM在FORM中的BLOCL和FIELD 记下,然后,在BLOCL中输入:$DESCRIPTIVE_FLEXFIELD$,?FIELD 中输入刚才记下的BLOCL。FIELD 在value 中的就是弹性域的标题如何查找form里的某个flexfield如何查找form里的某个flexfield如何查找form里的某个flexfield如何查找form里的某个flexfield
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;
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