What are Key and Descriptive Flexfield?

Key Flex Field: KFF is a Mandatory field which is already driving the functionality and it is the field where at least first segment is made mandatory.

·         KFF will be filled in segments

·         KFF is mandatory

·         KFF Drives functionality

·         Key flex field is nothing but a collection of segments. It stores data in code combinations.

·         As its name, it is used to capture ‘Key’ information of an organization which is mandatory like company, department, account etc.

·         It displays like simple text item

·         KFFs are flexible enough to let any organization use the code style they want, without programming.

·         Example of KFF is Revenue Account value on customer set up. Customer -> Bill To -> Account tab -> Revenue field

Navigation is Inventory (Navigator)->Setup->FlexField-Key->Segments then you can search for application and the flex field.

Examples: in Oracle Inventory

System Items, Stock Locators, Item Categories, Item Catalogs etc

Descriptive Flex Field: Descriptive flex field is the data which can be entered into the each of the oracle forms which can take extra information, and this option is there for almost all forms in oracle. you find the option of dff in every form that you work

·         DFF: Is not a mandatory field

·         DFF Information will go into attributes of the table

·         DFF does not drive any functionality but you can drive by writing a custom code on the dff fields.

·         DFF is used optionally to store any additional business information.

·         It displays like [] on screen

·         Programming may be required in DFFs

·         Example: DFF created in Alerts

Navigation is Inventory (Navigator)->Setup->FlexField-Descriptive->Segments then you can search for application and the flex field

Examples: in Oracle Inventory

System Items, subinventories, stock locators any other form

DFF	KFF
Capture Additional info	Unique Info, Mandatory
Captured in attribute prefixed columns	Segment prefixed
Not reported on standard reports	Is reported on standard reports
To provide expansion space on your form With the help of []. [] Represents descriptive Flex field. FLEX FILED : DESCRIPTIVE : REGIGSTER	Used for entering and displaying key information For example Oracle General uses a key Flex field called Accounting Flex field to uniquely identifies a general account. FLEX FILED : KEY : REGIGSTER

KFF & DFF share common features. They are multi segment fields. Application validates individual segments based on make value set rules & ensure that the segments make sense using CVR(cross validation rules).

Oracle Applications KEY FLEX FIELDS

1)     GL :- ACCOUNTING

2)     AR :- SALES TAX LOCATION, TERRITORY,

3)     AP :- BANK DETAILS, COST ALLOCATION, PEOPLE GROUP

Oracle Applications DESCRIPTIVE FLEX FIELDS (Partial)

1)     GL :-  daily rates

2)     AR :- credit history, information

3)     PA :- bank branch, payment terms, site address,