How to Register a Descriptive Flexfield (DFF) in an Oracle Form

In this blog post we will see the registration steps to enable a DFF in an Oracle form. In this example I will take the sales order headers screen to enable the DFF.

Following are the setup steps:

Oracle Apps - Overview of Flexfields

A flexfield is a flexible data field that your organization can customize to your business needs without programming. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is a field you can customize to enter multi-segment values such as part numbers, account numbers, and so on. A descriptive flexfield is a field you customize to enter additional information for which your Oracle Applications product has not already provided a field.

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;”