Custom Key Flexfield (KFF) in Oracle Applications

Posted by Manoj Madhusoodanan on Oracle Blogs See other posts from Oracle Blogs or by Manoj Madhusoodanan
Published on Tue, 3 Jul 2012 12:20:12 +0000 Indexed on 2012/07/03 15:21 UTC
Read the original article Hit count: 280

Filed under:

In this blog I will explain how to create a custom KFF.I am using XXCUST_KFF_DEMO table to capture the KFF code combinations.

Following steps needs to perform.

1) Register the XXCUST_KFF_DEMO table.Click here to see the code.

Verify the table has created successfully.

Navigation: Application Developer > Application > Database > Table

2) Register the Key Flexfield.

Navigation : Application Developer > Flexfield > Key Flexfields

3) Define the structure and segments.

 Navigation:  Application Developer > Flexfield > Key Flexfield Segments

Click on Segments button.

Save the created Information.Check the Allow Dynamic Inserts check box if you want to create the combination from the KFF display window. Once you complete all the changes check the Freeze Flexfield Definition check box.

4) Create a sequence XXCUST_KFF_DEMO_S.

5) Try to create KFF item through OAF or Forms. Here I am using a page based on table XXCUST_KFF_TRN.

You can see the output below.



© Oracle Blogs or respective owner

Related posts about /Apps