Monday, January 24, 2011
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
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
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
a. Flexifield qualifiers
b. Segment Qualifiers
c. Cross Validation Rules
d. Enable shorthand entries
a. Context sensitive Flexfields
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.