Enabling Descriptive Flexfield in Oracle Apps

A Flexfield is a field made up of sub-fields or segments. A Flexfield is a flexible data field that your organization can customize to your business needs without programming.

There are 2 types of flexfields,

·         Key Flexfield (KFF) and

·         Descriptive Flexfield (DFF)

Here, we are going to see more in detail about Descriptive Flexfield

A descriptive flexfield appears on your form as a two-character-wide text field with square brackets [ ] as it’s prompt.

DFF is used to track additional information, important and unique to your business that would not otherwise be captured by the form.

When opened, both KFF and DFF appears as a pop-up window that contains a separate field and prompt for each segment. Each segment has a name and a set of valid values. The values may also have value descriptions.

A segment is a single sub-field within a flexfield. A segment is represented in your database as a single table column.

Enabling Descriptive Flexfield in Oracle Apps

Navigate to the screen in which you want to enable DFF.

Here, the snapshots given are for enabling DFF in the Service Request Screen.
Click on square brackets [], No pop-up window will open which means that DFF is not enabled in this screen.

Once the window opens,

Go to Help à Diagnostics à Examine à

Enter the password. A window opens displaying the System Block (Nothing but Table Name). Copy the field in the System Block and Navigate as below

Application Developer Responsibility à Flexfield à Descriptive à Register

Descriptive Flexfield window opens. Query the copied System Block by entering in the Name Field.

Now, copy the Title and Navigate as below

System Administrator Responsibility à Applications à Flexfield à Descriptive à Segments

Descriptive Flexfield Segment window opens

Query using the copied Title in the Title field

Click Segments à Segment Summary Window opens à Enter the Segment and Column. If required you can associate Value Sets for the segments.

Save the changes and come back to Descriptive Flexfield Segment Window. Click on Freeze Flexfield Definition check box.

Compile the changes.

Now, Navigate to Service Request Screen

Click on the square brackets []. Now, you can see a pop-up window which means that the DFF is enabled in the Service Request Screen.
Articles Related to this Post
Defining Context Sensitive Segment in DFF
Value Sets in Oracle Apps