Implement PopList in OA Framework

Implement PopList in OA Framework

1. Create a New Workspace and Project

File> New > General> Workspace Configured for Oracle Applications

File Name -- PopListDemo

Project Name – PopListDemo

Default Package -- pop.oracle.apps.PO.lovdependentPRJ.webui

2. Create a New Application Module (AM)

Right Click on PopListDemo > New > ADF Business Components > Application Module

Name -- poplistdemoAM

Package -- pop.oracle.apps.PO.lovdependentPRJ.server

3. Create a New View Object (VO)

Right click on PopListDemo > New > ADF Business Components > View Object

Name -- poplistdemoVO

Package --  pop.oracle.apps.PO.lovdependentPRJ.server

Note - The VO is not based on any EO so click next and go to the query section and paste the query

select e.empno,e.ename from emp1 e,dept1 d where sal between '2000' and '5000' and  e.deptno=d.deptno and d.deptno='20';

4. Create a New Page

Right click on PopListDemo > New > Web Tier > OA Components > Page

Name -- poplistdemoPG

Package -- pop.oracle.apps.PO.lovdependentPRJ.webui

5. Select the poplistdemoPG and go to the strcuture pane where a default region has been created

6. Select region1 and set the following properties:

ID -- PageLayoutRN

AM Definition -- pop.oracle.apps.PO.lovdependentPRJ.server.poplistdemoAM

Window Title -- PopList Demo Window

Title – PopList Demo Header

7. Right click PageLayoutRN and  click new Region

ID -- MainRN

Region Style – messageComponentLayout

8. Verify Your VO attribute name

Select poplistdemoVO right click > Edit poplistdemoVO > Attributes >

Verify the Name it should be “poplist_items” if it is not then edit it and enter name “poplist_items”

9. Create the first Item (Empty Field)

MainRN > New > messageChoice

Set following properties for new item

ID – MyPopList

Required -- Yes

Picklist View Definition -- pop.oracle.apps.PO.lovdependentPRJ.server.poplistdemoVO

Picklist Display Attribute – poplist_items (Name of Attribute in  Your VO)

Picklist Value Attribute -- poplist_items

CSS Class – OraFieldText

Prompt – My PopList

(1)

(2)

End