In this blog post we will see the registration steps to enable a DFF in an Oracle form. In this example I will take the sales order headers screen to enable the DFF.
Following are the setup steps:
1. Go to Oracle order management responsibility:
a. Navigate to the following screen Orders. Returns -> Sales Orders & click on Sales orders screen.
b. Here is the DFF location highlighted in yellow.
c. Click on the highlighted location and open to see all the enabled DFFs on Order headers screen
d. Now as shown in the screen shot, note down the title of the DFF window – “Additional Header Information”.
2. Go to Application Developer responsibility.
a. Navigate to the following screen Flexfield -> Descriptive & click on Segmentsscreen.
b. This will open the Descriptive Flexfield Segments form.
c. Query the screen (F11) with the title – “Additional Header Information” which we noted down previously in setup1.
d. Now Unfreeze (Uncheck) the check box – “Freeze Flexfield Definition”.
e. Add the following field – “Attachment Details”. Provide an Attribute column (here ATTRIBUTE2) for this new field. So, whenever a value is entered into this field it will go and sit into a table column.
f. Click on “Open” button and make the required changed on this field, like if this field is a mandatory column (Required Check box) or not, the width of the column etc.,
g. After we are done with the changes, don’t forget to freeze the “Freeze Flexfield Definition” check box. The following message will pop up.
h. Compile the Flexfield definition to generate Flexfield view for order headers – OE_ORDER_HEADERS_ALL_DFV.
3. Now go back to Oracle Order Management responsibility:
a. And check if the new field which we added is showing up in the screen:
4. Now how will you identify the table in which this field value – Attachment Details is getting created.
a. Go to Application developer & navigate to Flexfield -> Descriptive & Click on Registerscreen.
b. Query the screen with the title which we got in 1.d setup (“Additional Header Information”)