弹性域能否控制不让用户更改

tiansoft68

弹性域能否控制让用户只能看，不能更改。

tiansoft68

没有哪位大师知道吗?目前有些用户自己手工更改弹性域,导致数据不对;

zhenghf

不能改还要弹性域做什么呢？

常志强

你将不想让用户修改的内容放置到说明栏位就好了，只显示出来

zzj19870112

什么弹性域？
只给一个值，看你怎么改{:soso_e120:}
或者设置了不显示出来行不行。。

tiansoft68

to 常志强  :
    说明栏位怎么设置?

tiansoft68

目标是: 只能看不能更改,

tiansoft68

没有哪位大师遇到这种问题吗？

appleteam

看起来目前是不支持，5楼的方法还真是ORACLE推荐的。

How To Make a Flexfield Segment As Read Only Or Restrict With Pre-Defined Value? [ID 420527.1]
Applies to:
Oracle Application Object Library - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 11-MAY-2013
Goal

The note describes the workaround to implement the following:

To make a Flexfield Segment as read only.
To populate a Flexfield Segment with some pre-defined value dynamically at runtime business logic.
To restrict users from entry in a particular segment of a Flexfield.


Solution

1. Create a table with two columns and will always hold a single row.

   Ex:
      Create Table Flex_Test(
                           Doc_No Number(20),
                           Cheque_No Number(16));

2. Open the Form having the Flexfield structure.
3. Find a suitable custom event / trigger in the form to fire the personalization rule.
4. Open the Personalization form from the pull down menu Help => Diagnostics => Custom Code => Personalize.
5. Create the personalization rule as follows:

  Condition :
  ------------
  Trigger Event : <Trigger Name>
  Trigger Object : <Object Name>
  Condition : NIL

  Action :
  --------
   Type : Builtin
   Builtin Type : FORMS_DDL
   Argument :
        =’Declare
            Begin
                 Delete from Flex_Test;
                 Insert Into Flex_Test Values(‘ ||<:Block_Name.Field_Name(Doc_No)>,<Cheque_No> ||’);
                 Commit;
           End;’

6. Save the personalization rule.
7. Create a Table validated list type Value Set with the table Flex_Test, which will list only one value.
8. Attach the Value Set with the Flexfield segment which is to be restricted from user entry.

appleteam

ORACLE说明的原因：
Personalizing the flexfield segments is not possible through forms personalization due to below reason:

A Flexfield is a single field in a Form but then when you click into it and it opens up the flexfields window,
the multiple fields you see is actually a user exit with multi segment values, not form fields.
No Form Personalization events are passed to flexfield windows (user exits).
No Form Personalization events are passed to segments inside the flexfield window (user exit).

If you want to disabled the segments, you can disable the segment
in flexfield definition form(Uncheck the enabled checkbox).

The flex developer has stated this would involve a major re-write of the flex code for APPCORE
to process forms personalization rules and actions pertaining to flexfields.
One need to understand that flexfields are not assigned to a canvas,
the flexfield UIs in forms are not native form fields but built on the fly with user exits.

Defaulting, populating, and or manipulating hidden fields for descriptive
flexfield attributes should not, and are not supported by flexfields to be
done through forms personalizations. Only Flexfields will support through
the flexfield setup and definition.

tiansoft68

谢谢!!!!!!!!!!!!!!!!!!!

zhenyuli2012

看英文好吃力啊{:soso_e130:}

13410504521

如果是可以改代码的话，那这个就很容易实习了

13410504521

    fnd_Descr_Flex.update_definition(
                                      BLOCK=>'PO_LINES',
                                      FIELD=>'DESC_FLEX',
                                  READ_ONLY=>'Y'
                                      );

tiansoft68

通过上面方式可以实现吗

VPQ743

有截图吗？你的目的是不想让用户在弹性域里面填东西？用你默认的值填到弹性域里面吗？