Falling short of DFF or KFF segment fields? How about KFF in DFF?
Just in time when I was planning to publish this article, the need for the same came from someone in the forums. Here is the requirement. Is there any way to pop up a key flexfield in the DFF segment or even in a key flexfield? Many a times, in mature global implementations, the need for the extra fields in many forms in insatiable. This article gives you simple steps to create a KFF in a DFF. You can extend the same to a KFF too.
Here are the steps:
Step1:
Create a KFF table in your custom schema with segment columns in there using the following SQLs in your custom. I am creating this table in AR schema.
Step2:
Create a synonym for the same in APPS schema using this.
Step3:
Register the table. You can only register the table using APIs (up until 10.7 GUI we were able to do this manually in Application Developer screens. But now we use API only). Use the following to do that.
Step4:
Verify the table registration. Register the KFF in that application. Check that the segment columns are enabled.
Step5:
Create a structure and enable as many as segments as you want. Make sure dynamic insert is enabled.
Step6:
Create a special value set based on this KFF. For special validation use the following for events:
Step7:
Choose a DFF where you want this KFF be available. Enable a segment in that DFF and assign this value set.
Step8:
Test your setup. If you save this DFF segment, CCID is stored in the DFF segment and a row goes into your table (KFF table) with that CCID and appropriate segments. If you update the segment, it will create another row with new CCID.
I sincerely thank Shabeer Mohammed, who executed this solution flawlessly, for sharing this solution with the community.
Nitin:
Good Blog Nag. This is a very common requirement in big and matured implementations as u meantioned. Especially in Single instance implementations of large enterprises.
Thanks,
12 July 2009, 6:28 amNitin jain
Kishore:
Very useful tip. I saw similar implementation where we popped set of segments on zoom.
Thanks for sharing this article.
Kishore
13 July 2009, 11:18 amChandra:
This was really helpful.
We are planning to use in Order Header screens, as we ran out existing DFF. We are planning to make 1 DFF available and replace with a custom KFF, so we can store infinite number of columns
But, we had one drawback. It stores one record in the database table for each combination, and not for each order. So we made Order number part of the KFF combinations as a workaround.
But, we now have a second problem. When we edit the same order after it was previously saved, and change the KFF values, it creates another record with the new combination. It does not update the existing combinations.
Regards
29 July 2009, 5:20 pmChandra
Ashot:
Hi,
12 August 2009, 4:44 pmI am having a problem with kff (gl code combination) in dff (inventory Items). The problem is when I update Organization item Dff -> kff it changes my item segments. could anybody help me?
Thanks
Chandra:
Ashot, We are experiencing the same issue.. if you find any solutions.. pls post it here.
Thx
14 August 2009, 6:14 pmChandra
Chandra:
Ashot, Check if this helps out http://www.neocortex.com/pdf/NeocortexFlexFields.pdf
Regards
17 August 2009, 2:25 pm-Chandra
Kiran:
why table registration is required for dff and kff, why not for forms or reports.
what is the reason behind ????
25 May 2010, 1:36 am