Monday, January 24, 2011
Difference between key flexfield and descriptive flexfield R12
In this post, i have shared the basic differences between Key flexfiled and descriptive flexfield collected from various blogs, oracle guides, books and other fellow bloggers. Hope it will be useful.
1. Business Purpose
· The business purpose of the KFF is to provide users a way to customize the key information structures and appearances in such a way that will be meaningful to a particular company.
· The business purpose of the DFF is to capture additional information based on the company’s specific need that would otherwise not be tracked or would have required a customization.
2. Database Structures
KFF:
a. Stored separately in a combination tables
b. Each segment of the KFF is mapped to a segment column in the combination table
c. Maximum number of segments in KFF depends on the number of segment columns available in the underlying combination table
d. A unique key is assigned to each unique KFF combination and is stored in the key ID column in the combination table
e. We can have a Unique identifier for the KFF structure and it is stored in the structure id column in the combinations table
DFF
a. Stored as part of the most of the oracle applications underlying database table, they are not stored in separate combination tables as like in KFF.
b. Each attribute of the DFF is mapped to a attribute column in the combinations table
c. Maximum number of attributes per context a DFF can have depends on the number of attributes available in the underlying combination table.
3. Flexfield Features
KFF:
a. Flexifield qualifiers
b. Segment Qualifiers
c. Cross Validation Rules
d. Enable shorthand entries
DFF:
a. Context sensitive Flexfields
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Difference between key flexfield and descriptive flexfield R12”
Post a Comment