Oracle Flex fields

Oracle flexfields is one of the most important parts of Oracle Applications.A flexfield, as the name suggests, is a flexible data field that you can implement using setup.

Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields.

Descriptive Flexfields
A descriptive flexfield is a field you customize to enter additional information for which your Oracle Applications product has not already provided a field.

Descriptive flexfields provide customizable ”expansion space” on your forms. Though the fields on an Oracle form are more than enough to capture all the possible information from the user perspective, but still the users can feel the need of capturing additional information. A descriptive flexfield gives you room to expand your forms for capturing such additional information.
A descriptive flexfield appears on a form as a single–character, unnamed field enclosed in brackets ([ ]) as shown in figure 3 below.



A window pops-up when you navigate to the key flexfield as shown in figure below and it would require you to enter the various segments defined for the key flexfield.

Key Flexfield

A key flexfield is a field you can customize to enter multi–segment values such as part numbers, account numbers, and so on.

This is will be useful if you want to capture the same set of values in many forms.

For example:
let’s assume that there is no such thing as a key flexfield. All we have is a descriptive flex

Requirement is this:-Your client wants to capture values in following additional fields for a purchase order transaction and invoices>...
Company name: GM
Cost Centre: IT
Project: OFP --means Oracle Fusion Project
Expense Type: OCC -- Oracle Consultant Cost