How to Create DFF with Value Set in Oracle apps EBS R12
First
of all we have to open the screen for which we are going to define the DFF.
After
selecting the DFF field go to
Help>>Diagnostics>>Examine
The
below screen will appear
In
the Block field select DESCRIPTIVE_FLEXFIELD from LOV in Field select PO_HEADERS from LOV
And
value will be automatically populated. Copy the Value of VALUE
field.
Now go to Application Developer>>
setup>> Flexfield>>Descriptive>>Segments
Now
Press F11 and Just paste the copied value in the Title field and press CTRL+F11
Uncheck
the Freeze Flexfield Definition then
press ok.
Click
on segment and fill the mandatory fields and save.
Click
on Value set and the below screen will appear. Fill the mandatory fields as per
our requirement.
After Click on Edit
Information on the above field the below
screen will appear. In the Table Name
field give the table names with aliases
.
In the value field give one column name with table name also
mention proper size and type.
In the where /Order By field give the proper condition.
In the additional Columns
field give the additional column name that we want to display.
Click on Test and close
the screen.
In this screen we have to
attach the value set name and save.
Close the screen.
Now Check the Freeze Flexfield checkbox and save
No comments:
Post a Comment