Understanding Flexfields in Oracle Fusion                                    Applications

Flexfields are one of the most powerful and customizable features in Oracle Fusion Applications. They enable organisations to configure additional fields, capture business-specific information, and maintain structure without modifying the core application code.

A Flexfield is essentially a field made up of multiple segments, where each segment captures a piece of information. Flexfields allow businesses to store structured data in a flexible way.

There are three main types of Flexfields in Oracle:

---

1. Key Flexfields (KFF)

Key Flexfields are mandatory flexfields used to capture key, essential, and uniquely identifying information of an organisation. They help structure transactional and reference data in a logical format.

Examples:

• GL Accounting Flexfield (used for creating the Chart of Accounts)
• Item Flexfield
• Location Flexfield

Key Points:

• Key Flexfields exist in Fusion Applications across modules.
• In General Ledger (GL), the Accounting Flexfield is used to build the Chart of Accounts (CoA).

---

Chart of Accounts (CoA) Setup in Fusion

The Chart of Accounts defines how financial information is recorded and reported. It consists of segments that represent different accounting dimensions, such as Company, Department, Cost Centre, Account, Project, etc.

CoA Segment Rules

• Maximum Segments: 30
• Minimum Segments: 2
• Primary Balancing Segment
• Natural Account Segment

These minimum segments ensure that accounting entries are balanced and classified correctly.

---

Step 1: Create Value Sets

Before creating CoA segments, you must create Value Sets, which control:

• What data can be entered
• How the values are validated
• Formatting rules such as length, type, or range

Navigation:
Setup and Maintenance → Financials → Financial Reporting Structures → Manage Chart of Account Value Sets → Create

Types of Validation for Value Sets

Independent Value Set

• Requires you to manually create segment values.
• Only values defined in the value set can be used.
• Commonly used in CoA segments like Company, Department, Cost Centre, etc.

---

2. Descriptive Flexfields (DFF)

Descriptive Flexfields are optional fields used to capture additional information not available in the standard Oracle form.
You can configure DFFs at:

• Header level
• Line level
• Entity level

DFFs are widely used to store business-specific attributes without customisation.

---

3. Extensible Flexfields (EFF)

Extensible Flexfields are an advanced version of DFFs, allowing you to create:

• Multiple contexts
• Multiple attribute groups
• Hierarchical data structures

EFFs are commonly used in:

• Procurement
• Inventory
• Product Management
  They are designed to support complex data capture requirements.

Steps -1

 Steps -2

Steps -3

Steps -4

Steps -5

Steps -6