Extending DFFs via KFF

There has always been a constraint on number of DFF and every big implementation looks for more number of DFF where additional information can be stored. Oracle by default provides only 15 attributes for single context value. I would outline the way we can overcome this constraint by creating custom KFF on DFFs and in a way make the number of DFFs as unlimited.

Step 1: Create a custom table and the corresponding custom sequence . Give grants to the Apps schema.

 

Step 2:  Create a synonym for both table name and sequence in APPS schema.

 

Step 3:  Register the table using the AD utility and also register the sequence using the FND_DICTIONARY_PKG.

 

Step 4: Register the KFF in the standard application. Also define the segments.

Step 5: Create a structure and enable as many as segments as needed. Also ensured the dynamic inserts is enabled. ** This design gives flexibility to create multiple structure for multiple form like invoice header, journal header, journal line etc.

 

           Step 6: Created a special value set for the edit, load and valid events.

Step 7: Add the value set to the DFF.

 

Viola.. Your KFF on DFF is ready.

**For implementing it through interface you just need a call to fnd_flex_ext API and that would generate the combination.

We need to create unique structure and special value set to implement it in multiple tables. This way one single custom table would serve to fill up as many as DFF we need. There will not be any limitations for using it.

 

Please reach out to me for technical details on how it can be implemented.