Descriptive Flexfields(DFF)

22 September, 2018


Related Blogs

The most powerful feature of Oracle Applications is the Flexfield feature. I t can be defined as “A flexfield is a field which contains sub-fields or segments” . There are two types of flexfields, Key flexfield (KFF) and descriptive flexfield (DFF). Both flexfields contain segments where each segment has a name and set of valid values. DFF is used to capture descriptive information. As Oracle has provided maximum fields to capture information on each screen but few companies still want to capture more data on certain screen but in a different way. For example on Oracle Assets you want to capture computers detailed information like RAM, HDD, CDD, Mother board etc. So one way for Oracle was to add such fields on the form for you but just think that Oracle Applications is not specific to computer companies. Here there is a need of DFF. I t is context sensitive and for each context value different fields would be available. Just for understanding let me give another example as DFF is bit confusing. A company requirement is to capture different detail of computer parts CDD, RAM, HDD, Monitor for each will have different sort of info, CDD: Make, Speed Monitor: Make, Size, Serial no So in the context value when the user will select CDD two fields Make, Speed will be displayed for input while on select of Monitor Make, Size and Serial no. I hope it would be enough for understanding DFF. 1. Locating Descriptive Flexfield (DFF) on the Form In this topic we will define a DFF on Paybles Invoice Distributions form. The first question is how we can know which DFF is for that form. So we will discuss that how to locate a DFF on a form. 1.1. Open the Invoices form, Payables: Invoices > Entry > Invoices 1.2. Search any entered invoice so you can move in the form or enter a new one. 98 1.3. Click on Distributions (button). 99 1.4. Open the Examine from Menu: Help > Diagnostic > Examine. 1.5. Provide the APPS password if prompted. 100 1.6. Note the value of Block D_SUM_FOLDER field and click the LOV button of Block field. 101 1.7. Select $DESCRI PTI VE_FLEXFI ELD$ and click OK (button). 102 1.8. Locate D_SUM_FOLDER here it is D_SUM_FOLDER.DI ST_DF and click OK (button). 103 1.9. Note the value displayed I nvoice Distribution (Payables) . Here the Invoice Distribution is DFF name and Payables is the name of application.   2. Defining Descriptive Flexfield (DFF) 2.1. Open the Segments form, Payables: Setup > Flexfield > Descriptive > Segments Or Sys Admin: Application > Flexfield > Descriptive > Segments 2.2. Search for Application Payables and Title Invoice Distribution. 104 2.3. Elements defined as Global Data Elements will be for each transaction so we can also call that these will be used as header. Soon you will know. 2.4. Enter the information in the required fields. 105 106 2.5. I have assigned Value Set 16 Characters so the length will be of 16 characters. I f you will not assign Value Set then a warning message will appear that it will truncate the field. I have created only one element so you can create more. 2.6. Save the data. 107 2.7. In the second line enter Freight as code and then click Segments (button). 2.8. Enter the following information.

Number Name Window Prompt Column
10 Common Common ATTRIBUTE1

108 2.9. Save the data. 2.10. Now we will define for Imports. 109 2.11. Click Segments (button). 2.12. Enter the following information.

Number Name Window Prompt Column
20 Shipment Number Shipment No ATTRIBUTE13
30 Expense Head Expense Head ATTRIBUTE15
40 Expense Sub Head Expense Subhead ATTRIBUTE2

110 2.13. Save and close this form. 2.14. Create another line for Insurance. 111  2.15. Click Segments (button). 2.16. Enter the following information.

Number Name Window Prompt Column
10 Name of Insurer Name of Insurer ATTRIBUTE1
20 Nature of Policy Nature of Policy ATTRIBUTE2
30 Next Premium Due Next Premium Due ATTRIBUTE3

112  2.17. Save and close this form. 2.18. On the main form create a line for Rent and enter the following information.

Number Name Window Prompt Column
10 Location Location ATTRIBUTE1
20 Address Address ATTRIBUTE2
30 Nature Nature ATTRIBUTE3
40 Monthly Rent Monthly Rent ATTRIBUTE4
50 Lease Term Lease Term ATTRIBUTE5

113 2.19. Save and close this form. 2.20. On the main form create a line for Utilities and enter the following information.

Number Name Window Prompt Column
10 Type of Expense Type of Expense ATTRIBUTE1
20 Period of Expense Period of Expense ATTRIBUTE2
30 Meter Number Meter Number ATTRIBUTE3
40 Telephone Number Telephone Number ATTRIBUTE4

114 2.21. Save and close this form. 2.22. On the main form create a line for Vehicle Running and enter the following information.

Number Name Window Prompt Column
10 Common Common ATTRIBUTE1

115 2.23. Save and close this form. 116 2.24. Enable Check box Freeze Flexfield Definition and save. The DFF definition will be compiled. 117 2.25. Click OK (button). 3. Entry in Defining Descriptive Flexfield (DFF) 3.1. Open the Invoices form, Payables: Invoices > Entry > Invoices 3.2. Create a new invoice. 118 3.3. Click Distribution (button). 3.4. Enter the required information. 119 3.5. Click the field labeled [ ] . 3.6. Here Customer Invoice No is our Global and this will be entered for all type of expenses. 120 3.7. Click the Select the Expense Type field. 121 3.8. Select Insurance (or any which you want to enter information for) and enter the information in the fields displayed for that Expense type. 122 Note: As we have not assigned any Value Set so here we can see that our fields length is truncated and we need to scroll. 3.9. Here I have selected Utilities and the fields are displayed which were defined for Utilities. 123              

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .