Oracle Apps – SCM Functional Interview Questions & Answers

Oracle Apps – SCM Functional Interview Questions & Answers

What is a DFF?
Descriptive Flexfield (DFF) is a tool that lets to create new fields in the forms.

Is the DFF’s are flexible?
DFF are flexible.

Example: Depending upon the value in a field, it can made as either Field1 or Field2 to appear in DFF. 

Can these new fields be added without modifying / customization of the screen?

Yes. Only some setup is needed to setup the DFF.

Can these new fields that get created as a result of DFF free text that is whether end user can enter any junk into the new fields that are added via DFF?
If user 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. 

Will the values that entered by the user in DFF fields be updated to database?
Yes, this happens because for each field that you create using DFF will be mapped to a column in Oracle Applications.

Can user create a DFF on any database column?
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 and ATTRIBUTE3 etc... Usually Oracle provides upto 15 columns, but this number may vary. 

Can user add hundreds of fields to a given screen?
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.

Is DFFs are related to table and columns?
Yes, 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.

Is it possible to appear these fields in screen only when certain conditions are met?
Yes, based on Context Sensitive Descriptive Flexfields