Tuesday, July 5, 2011

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

1 comment:

  1. I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

    Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

    Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

    ReplyDelete