Flexfield

Define:

Flexfield, as the name suggests, is a flexible data field that your organization can customize to your business needs without programming. Combining multiple columns into single Value.. for example:( bank account, university registration number)

It allows you to enter multi–segment values such as part numbers, account numbers

So all the columns augmented into one column called Flexfield.

Why:

Flex field concept is basically implemented in all oracle standard tables becuase if you are looking for any customization or enhancement of a particular oracle form then you can do so by using the additional columns provided in each standard oracle table.

Types:

1) Key Flexfield

2) Descriptive Flexfield

      

Key Flexfield:

key flexfield is a field made up of segments, where each segment has both a value and a meaning.

I will take my university registration number as an example.

My University Registration number is 120-06-205-114

Segment	Value	Meaning
Segment 1	120	College Code
Segment 2	06	2006 Batch
Segment 3	205	Department ID ( IT Dept )
Segment 4	114	Roll no

Consider Bank account number

A complete bank account number may consists of various segments like the country code, area code, city code, branch code, account type, account number etc.

Same way Indian Railways PNR Number will have several segments to trace the particular traveler details.

Key Flexfields in Oracle Applications

The Oracle Applications products provide many key flexfields as integral parts of the products.

Here is a table listing all the key flexfields in Oracle Applications, ordered by the application that ”owns” the key flexfield. Note that other applications may also use a particular flexfield

Owner	Key Flexfield Name	Flexfield Code
Oracle Assets	Asset Key Flexfield	KEY#
Oracle Assets	Category Flexfield	CAT#
Oracle Assets	Location Flexfield	LOC#
Oracle General Ledger	Accounting Flexfield	GL#
Oracle Human Resources	Grade Flexfield	GRD
Oracle Human Resources	Job Flexfield	JOB
Oracle Human Resources	Personal Analysis Flexfield	PEA
Oracle Human Resources	Position Flexfield	POS
Oracle Human Resources	Soft Coded KeyFlexfield	SCL
Oracle Inventory	Account Aliases	MDSP
Oracle Inventory	Item Catalogs	MICG
Oracle Inventory	Item Categories	MCAT
Oracle Inventory	SalesOrders	RLOC
Oracle Inventory	Stock Locators	MTLL
Oracle Inventory	System Items	MSTK
Oracle Payroll	Bank Details KeyFlexField	BANK
Oracle Payroll	Cost Allocation Flexfield	COST
Oracle Payroll	People Group Flexfield	GRP
Oracle Receivables	Sales Tax Location Flexfield	MKTS
Oracle Receivables	Territory Flexfield	CT#
Oracle Service	Oracle Service Item Flexfield	SERV
Oracle Training Administration	Training Resources	RES

 Yet to complete this post....................