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....................

Data Entry and Retrieval From Database Through Oracle Forms

These are the basic controls must known to both tech and functional people to enter and retrieve data via forms.
I will take concurrent program definition form as an example to explain you this

1) Login to oracle applications
2) System Administrator Responsibility
3) Function->Concurrent : Program-> Define




 Note: Yellow colored fields are required fields.Without filling all the yellow colored fields we can't save the data into database.



If you press save button   now.It will prompt for a message like "Field must be entered" at left bottom of the form as shown.

Once you enter all the data into all the required fields you can save the data..

Now if you click save button..you will get this prompt below..It means your data saved in database.


Now lets see how to  Retrieve the existing data from database through forms

To Retrieve the existing data from database press F11 key..Now you will be able to see you form as shown below..




Type "XX My Demo Conc Pgm" in Program Field and Press "Ctrl+F11" Key
Now you are able to see all the details what you entered in the database as shown below



You can try several cases like this
XX My Demo Conc% then press Ctrl + F11
Press down and up arrow key if you have more than one program name having same prefix.
Thank You.
We Will see What is Flexfield and Valueset in next post