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 Segments
screen.
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 Register
screen.
b. Query the screen
with the title which we got in 1.d setup (“Additional Header Information”)
