A training article on Descriptive flexfields, also refered as DFF
First some basic Question and answers, and then we will do screenshots detailing how flexfields are configured.
Question: What does DFF mean?
Answer: DFF is a mechanism that lets us create new fields in screens that are delivered by Oracle.
Question: Oh good, but can these new fields be added without modifying/customization of the screen?.
Answer: Yes, certainly. Only some setup is needed, but no programmatic change is needed to setup DFF.
Question: Why the word Descriptive in Name DFF?
Answer: I think Oracle used this terminology because by means of setup...you are describing the structure of these new fields. Or may be Oracle simply used a silly word to distinguish DFF from KFF(discussed in latter training lesson).
Question: Are these DFF's flexible?
Answer: A little flexible, for example, depending upon the value in a field, we can make either Field1 or Field2 to appear in DFF.
Question: So we create new fields in existing screen, but why the need of doing so?
Answer: Oracle delivers a standard set of fields for each screen, but different customers have different needs, hence Oracle lets us create new fields to the screen.
Question: Are these new fields that get created as a result of DFF free text?
I mean, can end user enter any junk into the new fields that are added via DFF?
Answer: If you attach a value set to the field(at time of setup of dff), then field will no longer be free text. The entered value in the field will be validated, also a list of valid values will be provided in LOV.
Question : Will the values that get entered by the user in dff fields be updated to database?
Answer: Indeed, this happens because for each field that you create using DFF will be mapped to a column in Oracle Applications.
Question: Can I create a DFF on any database column?
Answer: Not really. Oracle delivers a predefined list of columns for each table that are meant for DFF usage. Only those columns can be mapped to DFF segments. These columns are named similar to ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3 ETC. Usually Oracle provides upto 15 columns, but this number can vary.
Question: Can I add hundreds of fields to a given screen?
Answer: This depends on the number of attribute columns in the table that screen uses. Also, those columns must be flagged as DFF enabled in DFF Registration screen. Don't need to worry much about this because all the ATTRIBUTE columns are by default flagged for their DFF usage.
Question: Hmmm, I can see that DFFs are related to table and columns...
Answer: Yes correct. Each DFF is mapped to one table. And also each segment(or call it field) is mapped to one of the attribute columns in that table.
Question: I want these fields to appear in screen only when certain conditions are met. Is it possible?
Answer: Yes, we have something known as Context Sensitive Descriptive Flexfields.
In Order to do this, we will follow the below steps(screenshots will follow) :-
1. Navigate to the DFF Registration screen in Oracle Apps and query on Table AP_BANK_BRANCES. Now click on Reference Field
2. Navigate to DFF Segments screen and query on the Title of the “Bank Branch” and Unfreeze the Flexfield and add segments as to Section "GLOBAL Data Elements" as shown in screenshots.
Here are the screenshots......The descriptions are embedded within the screenshots.
We are in "Bank Branches screen" below, that is available in Payables responsibility. We need to add a new field as below.
Once having noted down the table, we try to find the Title of the DFF for that Table. We go to Flexfield/Register
Here we pick the Title of the respective DFF
Query on that DFF Title from Descriptive Flexfield Segment Screen
Add a new segment under "Global Data Elements"
The options for making mandatory or enabling validations for the new field.
Once you finalize the changes, you will be prompted to Freeze the DFF definition. Click on OK
Now, we see the fruits of our configuration
written by raivin , July 06, 2007
written by Hariom , July 10, 2007
written by APassi , July 10, 2007
written by An**et Mahajan , August 31, 2007
written by Lakshman Kalisetti , October 10, 2007
written by Ramesha , October 16, 2007
written by Ramesha , October 17, 2007
written by jith , October 20, 2007
written by sanjay desai , October 20, 2007
written by Venu Gopal Bhagavatula , November 19, 2007
written by Ramstein , November 19, 2007
written by S.kumar , November 22, 2007
written by Dhiman , November 27, 2007
written by Maheshyogi , November 27, 2007
written by Thulasee Ram , November 30, 2007
written by Deedee , November 30, 2007
written by Thulasee Ram , December 04, 2007
written by Dhiman , December 27, 2007
written by Vive , January 09, 2008
written by Abhishek Parihar , January 12, 2008
written by Rinku , January 25, 2008
written by ramarao kothapalli , February 01, 2008
written by Sachin Nanekar , February 14, 2008
written by kancharla , February 18, 2008
written by Avi , February 20, 2008
written by Avi , February 20, 2008
written by Shine , February 22, 2008
written by TUAN , May 01, 2008
written by Rajesh Kumar , August 25, 2008
written by Hi Anil , October 03, 2008
written by Swetha_gks , December 18, 2008
written by Anil- , December 18, 2008
written by Anand Ramaswamy , December 26, 2008
written by GANGA RAJU AEn**e , January 16, 2009
written by Asharma , April 08, 2009
written by Rishi , July 16, 2009
written by smyggymba , July 16, 2009
written by Murugesh , October 29, 2009
written by Premalbhai , November 16, 2009
written by syed hussain , January 15, 2010
written by sheetal mittal , March 11, 2010
written by kafajy , April 19, 2010
written by Pan , June 23, 2010
written by Vincent , September 14, 2010
written by Kadir Ard?ç , September 16, 2010
written by abi , November 23, 2010
written by Amal , February 10, 2011
written by JT , March 11, 2011
written by chi , March 18, 2011
written by Deepesh Aravandekar , March 23, 2011
written by Ananda , September 14, 2011
written by Attribute Update , September 16, 2011
written by Pritesh , February 18, 2012
written by Meron , March 05, 2012
|< Prev||Next >|