KFF AND KFF vs. DFF: Comparison

KFF (Key fLex Fields)
=====================

KFF will be used to Capture the Key Information in code language for every code
there will be specific meaning in the application.

For Ex: we can find some of the fileds like follows

Code Combination  01-001-1540-1234-0000

  01-Operations
 001-HRMS
1540-Furniture
1234-Sales Account
0000-No Product

 Description     : Operations-HRMS-Furniture-Sales Account-No Prodcut

like this we can find the meaning in the application for every code.

We will use the Segment Columns to Capture the KFF Data.
We can find the Segment coumns in most of the Tables like 
SEGMENT1,SEGMENT2,SEGMENT3,..........SEGMENT30.

Diff Between DFF and KFF

DFF     KFF
-----     ---
1)DFF Will be used to capture the Extra 1)KFF will be used to Capture the Key 
  Information.                            Information

2)ATTRIBUTE Columns will be used         2)SEGMENT columns will be used

3)We can have max DFF in the Application 3)We have 30KFF already defined by Oracle 
  there is no Limit       we can customize existing KFF. We are not
        suppose to define the new KFF. We will not
        get support from Oracle.
4)In DFF we will Context Field to define  4)In KFF we will define Structure Column 
  Multiple Strutures      to define the Multiple Structures.

P_FLEXDATA: Is a Lexical parameter will be used to store the default
 value as concatenation of all the segment columns.
This is required because if client changes the segment structure 
from front end again we have to change all the structure.
instead of that we can concatenate all the segments.

lexical parameter means datatype :char width : min 600

p_struct_num:
It will be used to store the  kff structure number which is required
if KFF is having the multiple structures.
Ex: 101 default value

FNDFLEXSQL: 
----------
This is One of the User exit will be used to retrive the segment 
values from database and will be used in the before report trigger
Parameters:
CODE              -KFF Code
num               -KFF structure Number
appl_short_name   -KFF Application ShortName
OutpuT            -Lexical parameter Name
Display           -Display all the segments
Mode              -'SELECT'


FNDFLEXIDVAL:
-----------
This user exit we will define inside of the formuls column to display
the data in the layout.
define the formula column call the user exit with follwoing parameters
Parameters:
CODE              -KFF Code
num               -KFF structure Number
appl_short_name   -KFF Application ShortName
OutpuT            -Lexical parameter Name
Display           -Display all the segments
Mode              -'SELECT'
data    -Lexical Parameter Name
Value             -Formula Column Name

Note :
To Display the KFF description we will define one more formula column
and we will call again 'FND FLEXIDVAL' user exit with parameter called
'Description' instead of 'Value' Parameter.