Loading

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

0 Responses to “Difference between key flexfield and descriptive flexfield R12”

Post a Comment

Disclaimer

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.