Create drop down list in oaf

Create drop down list in oaf

 

In this post we will create the Drop down list in the OAF page. I will share the detail steps to create this Drop down list. You can refer this post , to create the drop down list in the oaf page.

 

Steps to Create drop down list in oaf

1.Create a new workspace name "RohitPopList".
Right Click on "Applications".Click on "NewOAWorkspace".

Enter the name of Workspace="RohitPopList".Click Ok.

Project wizard will open as below click next.

Enter the name of the Project="RohitPopList".
Default Package= "rohit.oracle.apps.fnd.RohitPopList"

Package determines the directory where the java class files and other files related to this project strored.

In this directory oracle.apps.fnd must be required."fnd" is the oracle application shortname you can use other applications like "ak" in this.

Enter the RunTime connection details as below.Enter the E-business Suit Application User Name and Password.(already explained in the JDev installation).

Workspace and project has been created.

To create a "PopList" we need to creata a View Object(VO).My PopList will show the supplier list So that my view object is based on vendor master table.

Create a View Object(VO).

Right Click on the project "RohitPopList".Click New

Click on View Object and then OK.

Enter the View Object  name="SupplierListVO"

Defualt Package="rohit.oracle.apps.fnd.RohitPopList.server"

we create "View Object" under the "Server" directory of the project as OAF Standard.

Click next next and go to step 5 "SQL Statement".

Click Next and the Finish.View Object(VO) has created as below.

 

Now we create a OAF Page as below

Right Click on the Project "RohitPopList".Click New.

Click on the Page.Click on ok Button

Enter the Page Name="RohitPopListPG"

Default Package="rohit.oracle.apps.fnd.RohitPopList.webui"

we create the page under the webui under the project directory

Click Ok Page has been created.

When you click the "RohitPopListPG" Below structure pane has dispayed as below

Repalce the name of the "region1" with "PageLayoutRN" in the property inspector.
 
Click on the "PageLayoutRN".On the right hand side In the property inspector we  will set the AM for the this page









Right Click on the project "RohitPopList".Click New

Select Application Module and then Click Ok.

 Application Module wizard has open as below click next

Enter the Application Module name="RohitPopListAM"

Defualt Package="rohit.oracle.apps.fnd.RohitPopList.server"

we create "Application module" under the "Server" directory of the project as OAF Standard.

Click next and then finish.

Now our application module has been creted.Our next step is to attach the view object with the "Application Module" .Click on "EditRohitPopListAM".
Then the below screen has opened.
Select the SupplierListVO in the left hand side and then shuttle this to the right and then click next and then finish.

Now we attach the Application Module(AM) with the page so click on the "PageLayoutRN" in the structure. Go to the right hand side then attach the AM as below

 

 

Right Click on the "PageLayoutRN" and then new and then click  region.


Then region2 has created.

Replace the region2 name with "MainRN" in the proeprty Inspector.

Right Click "MainRN".Click New and then Click Item.

Item1 has created under the "MainRN"Region.Click on "MainRN". Go the property window in right hand side and then change ItemStyle=messagechoice

itemStyle=messagechoice.

Set the Prompt=Supplier in the Property Window.

Now we attach the View Object "SupplierListVO" with this item1.
Set the Below Property for the Item1.

Under Data in the Property Window

PickList View Definition=rohit.oracle.apps.fnd.RohitPopList.server.SupplierListVO.

PickList Display Attribute=Vendorname.

PickList Value Attribute=VendorId.

After this rebuild your project like below.Right Click on the Project "RohitPopList" and then click "Rebuild". 

After Compilation Right click on the project "RohitPopList" and then click run.

 

OutPut Of the Above Project .