Key Flexfields (KFF)

 KFF are used to capture mandatory or Key Business information of the Organization in coded format . Each Key Flex Field is having its won base Table.

A key flexfield is a field made up of segments, each of which has both a value and a meaning. You can think of a key flexfield as an “intelligent” field that your business can use to store information represented as codes.

Most organizations use codes to identify general ledger accounts, part numbers, and other business entities. Each segment in the code represents a characteristic of the entity. A combination of segment values, also known as a key flexfield code combination, uniquely describes a business entity stored in a key flexfield.

The organization decides the following four basic information for each key flexfield:

1. How many segments an entity has?
2. What each segment means?
3. What values each segment can have?
4. What each segment value means?

Few Key Flexfields in different oracle modules are:

Module: GL

1. Accounting

Module: HRMS

1. Job
2. Position
3. Grade
4. Personal Analysis   

Module: Inventory

1. Account Aliases
2. Item Catalogs
3. Item Categories
4. Sales Orders
5. Stock Locations
6. System Items

Module: Fixed Assets

1. Asset
2. Category
3. Location

Module: AR

1. Sales Tax Location
2. Territory

Note:

Flexfields consists of Structures > Structures consists of Segments > Segments consists of Value Set >Value Set consists of Parameters.

Main Tables:

FND_ID_FLEXS:

This table captures the information of all the Key FlexFields. The main columns in this table are:

• APPLICATION_ID ‐ Column consists of Application ID
• ID_FLEX_CODE ‐ Column KFF Code (like ‘GL#’, ‘AR#’ etc.)
• ID_FLEX_NAME  –  KFF Name (like ‘Accounting Flexfield’, ‘Category Flexfield’..etc.)
• APPLICATION_TABLE_NAME – Name of combination table (like ‘GL_CODE_COMBINATIONS’ , ‘FA_LOCATIONS’ etc.)

FND_ID_FLEX_STRUCTURES:

This table stores structure information about key Flexfields. Each Structure is uniquely identified by

• APPLICATION_ID – Module Code
• ID_FLEX_CODE  – Code of KFF
• ID_FLEX_NUM – Number of a Structure

FND_ID_FLEX_SEGMENTS:

It captures the information of Segments. Each Segment is Uniquely identified by

• APPLICATION_ID – Module Code
• ID_FLEX_CODE – Key Flexfield code
• ID_FLEX_NUM – Key flexfield structure number
• SEG_NUM – Segment number
• FLEX_VALUE_SET_ID – Flexfield value set identifier

FND_FLEX_VALUE_SETS:

This table captures the information of each Segment’s Value Set. Each Value Set is Uniquely identified by FLEX_VALUE_SET_ID as Foreign Key of FND_ID_FLEX_SEGMENTS Table.

FND_FLEX_VALUES:

This table captures the information each Value codes of a Value Set of a Segment. Each Value Code is uniquely identified by

• FLEX_VALUE_SET_ID
• FLEX_VALUE_ID

FND_FLEX_VALUES_TL:

This table captures the information of each Value Description of a Value Set of a Segment. Each Value Description is uniquely identified by FLEX_VALUE_ID.

AREA	KFF Name	TABELS
Inventory	Account Alias Flexfield	INV_GENERIC_DISPOSITIONS
General ledger	Accounting Flexfield	AP_INVOICE_LINES_ALL
		EXM_EXPENSE_DISTS
		EXM_SPEND_AUTH_DISTS
		FA_BOOK_CONTROLS
		FV_BE_TRANSACTION_ACCOUNTS
		FV_TR_FUND_ATTRIBUTES
		GL_ACCOUNT_ALIASES_B
		ZX_PROCESS_RESULTS
		GL_ESS_FILTER_SEGMENTS
		GL_JE_HEADERS
		PO_BUYER_ASSIGNMENT_RULES
		GL_CODE_COMBINATIONS
Assets	Asset Key Flexfield	FA_ASSET_KEYWORDS
		FA_ASSET_KEY_ALIASES_B
Budgetary Control	Budgeting Flexfield	XCC_BUDGET_ACCOUNTS
Assets	Category Flexfield	FA_CATEGORIES_B
		FA_CATEGORY_ALIASES_B
Cost Management	Consigned Flexfield	CST_VAL_UNIT_CONS_COMBINATIONS
		CST_VAL_UNIT_CONS_COMBINATIONS
Global Payroll	Cost Allocation Flexfield	PAY_COST_ALLOC_ACCOUNTS
		PAY_COST_ALLOC_KEYFLEX
Product Model	Item Categories	EGP_CATEGORIES_B
Assets	Location Flexfield	FA_LOCATIONS
		FA_DEPRN_TAX_AUTHORITIES
		FA_LOCATIONS_PRTL
		FA_LOCATION_ALIASES_B
Inventory Management	Locator Flexfield	INV_ITEM_LOCATIONS
Global Human Resources	People Group Flexfield	PER_PEOPLE_GROUPS
Revenue Management	Pricing Dimensions Flexfield	VRM_PRICING_COMBINATIONS
Cost Management	Valuation Unit Flex field	CST_VAL_UNIT_COMBINATIONS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

select  FIF.APPLICATION_ID  ,         FIF.ID_FLEX_CODE    ,         FIF.ID_FLEX_NAME    ,         FIF.APPLICATION_TABLE_NAME ,         FIF.DESCRIPTION     ,         FIFS.ID_FLEX_NUM    ,         FIFS.ID_FLEX_STRUCTURE_CODE  ,         FIFSE.SEGMENT_NAME,         FIFSE.SEGMENT_NUM,         FIFSE.FLEX_VALUE_SET_ID from    FND_ID_FLEXS FIF    ,         FND_ID_FLEX_STRUCTURES FIFS ,         FND_ID_FLEX_SEGMENTS FIFSE where   FIF.APPLICATION_ID = FIFS.APPLICATION_ID and     FIF.ID_FLEX_CODE   = FIFS.ID_FLEX_CODE and     FIFSE.APPLICATION_ID = FIF.APPLICATION_ID and     FIFSE.ID_FLEX_CODE = FIF.ID_FLEX_CODE and     FIFSE.ID_FLEX_NUM = FIFS.ID_FLEX_NUM and     FIF.ID_FLEX_CODE LIKE 'GL#' and     FIF.ID_FLEX_NAME LIKE 'Accounting Flexfield';