Showing posts with label DFF. Show all posts
Showing posts with label DFF. Show all posts

Conditionally disable DFF components in Oracle apps

A frequent requirement in most Oracle Applications implementations is to be able to conditionally disable one of the components of a Descriptive Flexfield (DFF). DFFs follow the “all or none law” for a given DFF context. If a DFF is displayed, it is enabled and can be changed. The only exception to this rule is when the entire record is read-only. However, if your DFF is using five attributes, there is no mechanism to disable one attribute out of the five attributes. Also, since the DFF window is a user exit call, you cannot disable any attribute field by using set_item_property. We’ll show you how to protect DFF using CUSTOM.pll.

Make a DFF Non Editable

How to make a DFF field Non Editable:
  • Go to the DFF Definition screen for the particular context value
  • Select the Particular DFF Attribute
  • Open the Valueset attached to it
  • In the value set “Edit information”, provide the following values in “Event Edit” & “Event Validate”
    • FND SQL “BEGIN NULL; END;”