Key Flexfield ( KFF ) in Oracle Apps

Overview of Flexfields:

A flexfield is a field made up of sub–fields, or segments. There are two types of flexfields: key flexfields and descriptive flexfields.

Key Flexfields:

A Key flexfield is a field made up of segments, where each segment has both a value and a meaning, which appears on your form as a normal text field with an appropriate prompt.

One example of a key flexfield is the Accounting Flexfield. This flexfield can always be customized to have as many segments as needed like Company, Department, Cost center, Account etc.

  • In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations. Two types of flexfields are provided: key flexfields, which are required to record key data elements in Oracle applications, and descriptive flexfields, which are user-defined and record data elements that aren't automatically provided.

 

  • A segment is a single sub-field within a flexfield. You define the appearance and meaning of individual segments when customizing a flexfield. A segment is represented in your database as a single table column.

 

  • For a key flexfield, a segment usually describes a particular characteristic of the entity identified by the flexfield. For example, you can have a key flexfield that stores part numbers. The key flexfield can contain the part number PAD-YEL-NR-8 1/2x14, which represents a yellow, narrow ruled, 8 1/2" x 14" note pad. Each section in the part number, separated by a hyphen, describes a characteristic of the part. The first segment describes the object, a note pad, the second segment describes the color of the object, yellow, and so on.

 

           Note that we also refer to the fields in a descriptive flexfield pop-up window as segments even though they do not necessarily make up meaningful codes like the segments in key flexfields.                However, they do often describe a particular characteristic of the entity identified elsewhere on the form you are using.

 

             Here is the list of Key Flexfields availble in oracle applications:

      APPLICATION NAME

        FLEXFIELD TITLE

  • Asia/Pacific Localizations
  • Account Structure
  • Assets
  • Asset Key Flexfield
  • Assets
  • Category Flexfield
  • Assets
  • Location Flexfield
  • Capital Resource Logistics - Assets
  • Group Asset
  • Capital Resource Logistics - Assets
  • Super Group
  • Common Modules-AK
  • FWK Item Flexfield
  • Complex Maintenance Repair and Overhaul
  • AHL Operation
  • Complex Maintenance Repair and Overhaul
  • AHL Route
  • E-Business Tax
  • eBTax Context Flexfield
  • Enterprise Performance Foundation (Obsolete)
  • Activity Flexfield
  • Enterprise Performance Foundation (Obsolete)
  • Cost Object Flexfield
  • Financial Intelligence (Obsolete)
  • Management Flexfield
  • General Ledger
  • Accounting Flexfield
  • General Ledger
  • GL Ledger Flexfield
  • General Ledger
  • Reporting Attributes:Accountin
  • Human Resources
  • CAGR Flexfield
  • Human Resources
  • Competence Flexfield
  • Human Resources
  • Grade Flexfield
  • Human Resources
  • Item Contexts Keyflex
  • Human Resources
  • Job Flexfield
  • Human Resources
  • Personal Analysis Flexfield
  • Human Resources
  • Position Flexfield
  • Human Resources
  • Soft Coded KeyFlexfield
  • Inventory
  • Account Aliases
  • Inventory
  • Item Catalogs
  • Inventory
  • Item Categories
  • Inventory
  • ORACLE_SERVICE_ITEM_FLEXFIELD
  • Inventory
  • Sales Orders
  • Inventory
  • Stock Locators
  • Inventory
  • System Items
  • Learning Management
  • Training Resources
  • Oracle Environmental Accounting and Reporting
  • Environmental Reporting
  • Payroll
  • Bank Details KeyFlexField
  • Payroll
  • Cost Allocation Flexfield
  • Payroll
  • People Group Flexfield
  • Public Sector Budgeting (Obsolete)
  • PSB Position Flexfield
  • Receivables
  • Sales Tax Location Flexfield
  • Receivables
  • Territory Flexfield
  • Service
  • Oracle Service Item Flexfield