Blog Archives

Descriptive Flex-fields DFF in Oracle Apps

Descriptive flex-fields lets you add additional fields to the form in order to track additional information needed by the business that would not be captured by the standard form. Descriptive flex-fields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.

A descriptive flex-field appears on a form as a single–character, unnamed field enclosed in Square Brackets [ ]. Each field or segment in a descriptive flex-field has a prompt and can have a set of valid values.

Descriptive Flex-field Concepts:

Descriptive flex-fields have two different types of segments, global and context–sensitive.

A global segment is a segment that always appears in the descriptive flex-field pop–up window.

A context–sensitive segment is a segment that may or may not appear depending upon what other information is present in your form.

A descriptive flex-field can get context information from either a field somewhere on the form, or from a special field (a context field) inside the descriptive flex-field pop–up window. If the descriptive flex-field derives the context information from a form field (either displayed or hidden from users), that field is called a reference field for the descriptive flex-field.

For Example , Had Taken the Purchase order form and enabled the DFF Field.

Go to Purchasing —>Purchase order–> Purchase Order


To enable DFF Go to

Switch Responsibility to Application Developer.

Define Value Set:

Switch Responsibility to Application Developer–>Flexfield—>Descriptive–>Sets.

Value sets are defined to identify the valid values that are permissible for each segment of the Chart of Accounts.

Then Define the Descriptive FlexField Segments.

Go to Application developer-flexfield–>Descriptive–> Segments

Query with the Application as’ Purchasing’ and Title as ‘PO Headers’

Before Entering you have Uncheck the Freeze Flexfield Definition. Then check the Required context fields.

Then click on the Segments. Enter the Segments which will reflect in the Purchase Order DFF Field

Save it . Then Check the Freeze Descriptive Definition and compile it.

The DFF can be disable by Unfreeze the DFF segments first and Uncheck the Enabled check box of Descriptive Flexfield Segments .After Disabling the DFF Segments Check the Freeze Flexfield Definition and Compile the segment.

Then go to View–> Request–>find. Will see the Concurrent Program” Flexfield View Generator” running. After the Completion of the concurrent Program we can view the DFF in the purchase order form.

Switch resp to Purchasing–>purchase order—> Purchase Order