【EBS FORM】键弹性域在FORM中的定义

最新推荐文章于 2021-05-31 01:36:36 发布

转载最新推荐文章于 2021-05-31 01:36:36 发布 · 277 阅读

本文详细介绍了Oracle E-Business Suite中Flexfield的配置方法，特别是fnd_key_flex.define过程的参数及其作用，并解释了WHERE_CLAUSE的用途及限制条件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

官方文档：Oracle E-Business Suite Developer’s Guide：20-20

完整定义：

点击(此处)折叠或打开

fnd_key_flex.define(
/* Arguments that specify flexfield location */
BLOCK => 'block_name',
field => 'concatenated_segments_field_name',
description => 'description_field_name',
id => 'Unique_ID_field',
data_field => 'concatenated_hidden_IDs_field',
/* Arguments that specify the flexfield */
appl_short_name => 'application_short_name',
code => 'key_flexfield_code',
num => 'structure_number',
/* Other optional parameters */
validate => '{FOR_INSERT|FULL|PARTIAL|NONE|PARTIAL_IF_POSSIBLE}',
vdate => 'date',
displayable => '{ALL | flexfield_qualifier | segment_number}\\0{ALL | flexfield_qualifier | segment_number}',
insertable => '{ALL | flexfield_qualifier | segment_number}\\0{ALL | flexfield_qualifier | segment_number}',
updateable => '{ALL | flexfield_qualifier | segment_number}\\0{ALL | flexfield_qualifier | segment_number}',
vrule => 'flexfield qualifier\\n
segment qualifier\\n
{Include|Exclude}\\n
APPL=application_short_name;
NAME=Message Dictionary message name\\n
validation value1\\n
validation value2...
\\0flexfield qualifier\\n
segment qualifier\\n
{Include|Exclude}\\n
APPL=application_short_name;
NAME=Message Dictionary message name\\n
validation value1\\n
validation value2...',
copy => 'block.field\\n{ALL | flexfield qualifier | segment_number}\\0block.field\\n{ALL | flexfield qualifier | segment_number}',
derived => 'block.field\\nSegment qualifier',
derive_always => '{Y|N}',
dinsert => '{Y|N}',
valatt => 'block.field\\nflexfield qualifier\\nsegment qualifier',
title => 'Title',
required => '{Y|N}',
autopick => '{Y|N}',
usedbflds => '{Y|N}',
allownulls => '{Y|N}',
data_set => 'set number',
column => '{column1(n) | column1alias(n) , column2(n),... INTO block.field}',
where_clause => 'where clause',
combqp_where => '{where clause|NONE}',
where_clause_msg => 'APPL=application_short_name;NAME=message_name',
query_security => '{Y|N|}',
qbe_in => '{Y|N}',
read_only => '{Y|N}',
longlist => '{Y|N}',
no_combmsg => 'APPL=application_short_name;NAME=message_name',
autocombpick => '{Y|N}',
lock_flag => '{Y|N}',
help => 'APPL=application_short_name;TARGET=target_name');

项目中用到了WHERE_CLAUSE，查了一下官方文档，以下是官方解释，
官方文档描述使用了WHERE_CLAUSE以后，可以设置一个错误信息，但我设置了以后，依然不能第一时间展示，需要点错误的详细信息才能看到自定义的消息。

WHERE_CLAUSE：

Key flexfields only. Specify a WHERE clause to restrict which code combinations to display in the list of values
window. This argument also prevents a user from entering a combination that does not fit the WHERE clause. This
argument should not normally be used for a flexfield on the combinations form, since you would usually want to
display all combinations on the combinations form. Do not specify the word “WHERE” in this WHERE clause argument.
You should use this token with flexfields that do not allow dynamic inserts, either using DINSERTS as N or preventing
dynamic inserts at the structure level. You should not use the WHERE_CLAUSE argument for a flexfield that allows dynamic inserts.
Use the WHERE_CLAUSE_MSG argument to specify an appropriate message to display to the user when a
combination violates your WHERE clause.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29599494/viewspace-2112422/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29599494/viewspace-2112422/