Goal: Define new DFF segment in Transactions Form and make it read only to Receivables Manager responsibility. All other responsibilities will have access to enter and edit the values and Receivables Manager will have access to only read but not edit and enter the value.

You cannot make DFF segment read-only through personalization but you can restrict users from changing the value in DFF segment through personalization by displaying error message when they try to save the form.

Steps:
1. Define New Segment for DFF in Transactions forms.
2.
Define Security Rules
3.
Test it.

If you are not familiar with enabling the DFF (Descriptive FlexFields) click here

Define new SEGMENT for DFF in Transactions Form

Navigation: Receivables Manager >> Transactions >> Transactions

alt

alt

click on the box which is enclosed in []

alt

So we have already one segment Available.

DFF that I have in this form is

Title Transaction Information
Application Receivables

And it has one segment enabled and displayed.

Navigation: Application Developer >> Flexfield >> Descriptive >> Segments

altalt

Enter F11 and then fill the information

 

Application: Receivables

Title: Transaction Information

Do CTL + F11

alt

uncheck the “Freeze Flexfield Definition”

alt

Click OK

Now the screen looks like this.

alt

alt

Add New Segment by clicking + Icon on the toolbar and enter the following information

Number 10
Name ERP DEMO
Window Prompt ERP DEMO
Column ATTRIBUTE11

Value Set: erp_demo (click here to see how to define value set)

alt

Click open

alt

Check Security Enabled Flag and uncheck the Required flag

save (CTL+S)

Close it.

Close Segments Screen.

Check the Freeze Flexfield Definition check box

alt

Click OK.

Save it.

altalt

Click OK.

Close this Form.

Define Security Rules

Navigation: System Administrator Responsibility >> Security >> Responsibility >> ValueSet >> Define

alt

Click to open

alt

Enter existing value set name erp_demo which we assigned to DFF segment that we defined above.

alt

Click Find

alt

Enter the following information

Name erpschools
Description erpschools.com
Message erpschools.com demo

In Security Rile Elements

Type Exclude
From A
To D

Add New record and enter

Type Include
From Don’t fill anything
To Don’t fill anything

alt

Save it.

Click on Assign Button to restrict this functionality to a specific responsibility. This is optional.

alt

Enter the following information

Application Receivables
Responsibility Receivables Manager
Name erpschools

alt

Save and close.

Testing:

To test the changes Navigate to any Receivables Responsibility like US Receivables Manager which has access to Transactions form and query up any record.

Then navigate to DFF and enter some value for ERP DEMO and save the record.

Come back to Receivables Manager responsibility and query up the same transaction which you saved above.

alt

Define New ValueSet:

alt

To assign values to this value set follow the navigation path below and do accordingly

Navigation: Application Developer >> Flexfield >> Descriptive >> Values

altalt

Related Articles:

  1. Drop Ship Cycle
  2. Change displayed data in LOV using Forms Personalization
  3. Customizing Self Service Applications using Personalizations
  4. Using CALL_FORM to invoke another form in Oracle Applications
  5. Sub Functions In Oracle Applications

admin

  6 Responses to “Make DFF Segment readonly through Security Rules”

  1. Hi ,

    Thanx for the fonderful post.

    I got one requirement like in personalization, If any on help me out on this I will be very thankful to them.

    My Requirement is : I have 2 dff fields in sales order form, If I enter any value in 1st dff field it should be copy to 2 dff field. if it is possible, Please post ASAP.

    Thanks in Advance….
    Karunakar

  2. Thank You Sooo Much..Wanted to know this since long time..

  3. Can we use Validation type = NONE in the above example. Also I have a requirement to restrict update on a DFF in AR Transaction form to only a specific responsibility. There is no validation required for the DFF dta element. Any tips is much appreciated

  4. Thanks for such a nice article..

    i have some issues..
    according to my requirement, i have to make 2 attributes non-editable and 1 editable.
    By following your article.. i made DFF attributes (2) non-editable.

    i was success till here..

    but when i edit the other item which is editable, its giving my custom error msg, which is applicable for non-editable dff attributes..

    have you faced any issue like this? please guide me..

  5. Hi,

    thanks for this. I had a query. Did not quite get the Value set bit. What exactly is the A to D in the value set mean?
    thanks
    Shiv

  6. Hi,
    thank you much for the great post. since i could not find value set with “None” validation type in the “security> respon…> value set> define”, I would like to know whether we can use the same instriction for the value set with “None” validation type or not?
    Best Regards,
    Shiva

 Leave a Reply

[Social Login] Please enable at least one social network!

*

*


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© 2011 erpSchools Suffusion theme by Sayontan Sinha