Question

what are the steps Required Invoke Key Flex Fields from the Form in oracle Apss?

Answer 1

Steps Required Invoke Key Flex Fields from the Form
1 Create a KFF Table in Module Specific Schema.
2 Create a Public Synonym in APPS Schema.
3 Register the Table with AOL Module.
4 Register KFF with AOL Module.
Note: When ever we register a KFF, System internally generates a Structure with the same name as Title of the KFF and the Structure_ID.
5 Create the Structure of KFF.
6 Associate Segments to the Structure.
7 Define Value Sets.
8 Assign Value Sets to Segments.
9 Define Values to each Segment based on Value Sets.
10 Open TEMPLATE.fmb Form in Form Builder.
11 Perform all the prerequisites to develop the form.
12 Include all the KFF Columns in Data Block with NULL Canvas.
13 Create a Text Item in the Data Block and change the following properties.
Name : KFF
SubClass : Text_Item
Database Item : NO
LOV : Enable_List_Lamp
Validate From List : NO
Canvas : Canvas_Name
14 Create a Package Specification in Program Unit with a KFF Procedure and the name of the package is same as Block Name.
PROCEDURE KFF (EVENT IN VARCHAR2);
To see the Enable DFF
Go to Forms
Click on DFF Button
Open the DFF Window with Invoked Fields 46
15 Create Package Body in Program Unit.
PROCEDURE KFF (EVENT IN VARCHAR2) IS
BEGIN
IF EVENT = ‘WHWN‐NEW‐FORM‐INSTANCE’ THEN
FIND_DESCR_FLEX.DEFINE (‘EX_ORDERS’,’KFF’,’EX’,
‘Code_Of_KFF’,’Structure_Code_No’);
‐‐‐ FIND_DESCR_FLEX.DEFINE (‘Block_Name’,’Item_Name’,
‐‐‐ ‘Application_Short_Name’, Code_Of_KFF’,’Structure_Code_No’);
END IF;
END;
16 Call the KFF procedure in WHWN‐NEW‐FORM‐INSTANCE Trigger at Form Level and passing the event as WHEN‐NEW‐FORM‐INSTANCE.
17 Call FND_FLEX.EVENT in WHEN‐NEW‐ITEM‐INSTANCE Trigger at form level.
Note: FND_FLEX.EVENT is a common Built‐In used to invoke DFF and KFF.
18 Save and Compile the form and copy .fmx file in to module specific forms directory.
19 Perform all the prerequisites to register the form.