top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

0 votes
138 views
what are the steps Required To Invoke Descriptive Flex Fields (DFF) in Oracle Apps?
posted Dec 1, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Dec 2, 2015 by Arun Gowda
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...