Oracle applications – What is a FlexField ? What are Descriptive and Key Flexfields ?
- Oracle Applications : Descriptive Flexfields Overview and the SQL to find the Columns & Details.
- Oracle applications – List of Key flex fields and the tables associated with it.
- Oracle Applications: Key Flex Field Structures & How to Retrieve Information.
- Oracle Applications : Descriptive Flex Field FAQs
- Oracle Application interview questions – Techno-functional areas.
A flexfield is a placeholder set of fields that can be configured by customers for use by their organizations. Once configured, the customer-defined fields (label/widget pairs) may appear in either form or tabular layouts. There are two main types of flexfields: Descriptive flexfields, which are configured as a set of fields that are indistinguishable from core (default) application fields, and key flexfields, which consist of multiple segments for entry of codes, such as a product serial numbers or bank account numbers.
Flex field is collectoin of fields or segments. There are 2 types of Flex feilds.
1) Discriptive Flex Feld:- We can extend the functionality of the form without changing the code.
2) Key flex field:- It is also known as Intelligent code which stores valid code combinations.
A flexfield is made up of sub-fields or segments.. A flexfield appers on ur form as a pop-up window that contains a prompt for each segment.Each segment has a name and a set of valid values..
Two types of Flex field..
Key Flexfield: Key flexfield are flexible enough to let any organization use the code scheme they want wothout programming.Key flexfield can be used to represent codes that is made up of meaningful segment to identify GL a/c Part no. and other business entities..Oracle app store these codes in key flexfields..
Descriptive Flexfield: They provide customizable expansion space on ur forms. You can use desc flexfields to tract additional information important and unique to ur business that would not otherwise be captured by the form.

Hello Jay,Thanks very much for all the good information that you have taken the time to provide. I am trying to understand how to change DEFAULT key flexfield values such as accounts in Fixed Assets as an example. So in FA, we would like to show one account combination to show up as the default when we do additions of an asset or retire or dispose of an asset. (I think this is done through key flexfield values somehow-perhaps I’m wrong).
thanks in advance-RSN