官方文档:Oracle E-Business Suite Developer’s Guide:20-20
完整定义:
项目中用到了WHERE_CLAUSE,查了一下官方文档,以下是官方解释,
官方文档描述使用了WHERE_CLAUSE以后,可以设置一个错误信息,但我设置了以后,依然不能第一时间展示,需要点错误的详细信息才能看到自定义的消息。
WHERE_CLAUSE:
完整定义:
点击(此处)折叠或打开
- 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:
- 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/