- OracleApps Epicenter - http://www.oracleappshub.com -

AOL – Flex Field (Part -1)

Some one requested last week to provide some information about flex fleld concept. Thought its good to take all into one.Next couple of post will focus on Flex field concept, need and design for custom requirement.

Oracle applications use key flex field to represent intelligent keys with unique ID numbers. ID numbers require only one column while intelligent keys will require multiple columns (one for each section or segment of the code).

Flexfield - A field made up of one or more segments. A segment corresponds to a column in an Oracle table.
Each segment has an assigned name and may have assigned data validation rules (Validation Sets).

Key Flexfield - A Key Flexfield represents an intelligent key that uniquely identifies an application entity. These keys identify accounts, part numbers etc. Each key flexfield has an assigned name and a specified set of valid values.
Examples: in G/L we have the Accounting Flexfield (Chart of Accounts); in Inventory it is the Item Flexfield, in Projects the Job Flexfield.

Descriptive Flexfield - Allows for the capture of additional information not stored in the default application, or strictly for reference when viewed on a screen.
You may create a Flexfield using any of “Attribute(n)” columns. Oracle reserved “Attribute(n)” columns on most of the tables to be setup during installation. These columns are not used by Oracle standard functionality.
You may expand the number of Flexfield values by using “context sensitive” feature.

Flexfield Types /What is the difference between a key flexfield and a descriptive flexfield?

Key Flexfield:

An intelligent key that uniquely identifies an application entity. Each key flexfield segment has a name you assign, and a set of valid values you specify.

Descriptive Flexfield

A field that your organization can extend to capture extra information not otherwise tracked by Oracle Applications. A descriptive flexfield appears in your window as a single character, unnamed field. Your organization can customize this field to capture additional information unique to your business. (Example: capturing state codes on selected journal lines)

Flexfield Key Terms

What is Accounting Flexfield

When to use a KFF

Will take a deep drive for KFF and DFF in next post.

1 Comment (Open | Close)

1 Comment To "AOL – Flex Field (Part -1)"

#1 Comment By daniel nieto On January 2, 2009 @ 2:26 pm

Excellent article. I would want to suggest to include where we can see the fields once we have defined them.

Thank you,