Search This Blog

Monday, November 12, 2012

Difference Between KFF and DFF in Oracle Apps



Difference Between KFF and DFF in Oracle Apps
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

No comments:

Post a Comment