Question

what are the steps Required To Invoke Descriptive Flex Fields (DFF) in Oracle Apps?

Answer 1

Create a DFF Table in Module Specific Schema.
2 Create a Public Synonym in APPS Schema.
3 Register the Table with AOL Module.
4 Register DFF with AOL Module.
5 Open TEMPLATE.fmb Form in Form Builder.
6 Perform all the prerequisites to develop the form.
7 Include all the DFF columns in Data Block with NULL Canvas.
8 Create a Text Item in the Data Block and change the following properties.
Name : DFF
SubClass : Text_Item_Desc_Felx
Database Item : NO
LOV : Enable_List_Lamp
Validate From List : NO
Canvas : Canvas_Name
9 Create a Package Specification in Program Unit with a DFF Procedure and the name of the package is same as Block Name.
PROCEDURE DFF (EVENT IN VARCHAR2);
10 Create Package Body in Program Unit.
PROCEDURE DFF (EVENT IN VARCHAR2) IS
BEGIN
IF EVENT = ‘WHWN‐NEW‐FORM‐INSTANCE’ THEN
FIND_DESCR_FLEX.DEFINE (‘EX_ORDERS’,’DFF’,’EX’,’EXDFF’);
‐‐‐ FIND_DESCR_FLEX.DEFINE (‘Block_Name’,’Item_Name’,
‐‐‐ ‘Application_Short_Name’,’Name_Of_DFF’);
END IF;
END;
11 Call the DFF procedure in WHWN‐NEW‐FORM‐INSTANCE Trigger at Form Level and passing the event as WHEN‐NEW‐FORM‐INSTANCE.
12 Call FND_FLEX.EVENT in WHEN‐NEW‐ITEM‐INSTANCE Trigger at form level.
45
Note: FND_FLEX.EVENT is a common Built‐In used to invoke DFF and KFF.
13 Save and Compile the form and copy .fmx file in to module specific forms directory.
14 Perform all the prerequisites to register the form.
To Enable the DFF
Go to Flex Field
Descriptive
Segments

To see the Enable DFF
Go to Forms
Click on DFF Button
Open the DFF Window with Invoked Fields