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 -- prajkumar.oracle.apps.fnd.poplistdemo

2. Create a New Application Module (AM)
Right Click on PopListDemo > New > ADF Business Components > Application Module
Name -- poplistdemoAM
Package -- prajkumar.oracle.apps.fnd.poplistdemo.server

3. Create a New View Object (VO)
Right click on PopListDemo > New > ADF Business Components > View Object
Name -- poplistdemoVO
Package -- prajkumar.oracle.apps.fnd.poplistdemo.server
Note - The VO is not based on any EO so click next and go to the query section and paste the query

SELECT  'poplist_item1' poplist_items
FROM     DUAL
UNION
SELECT  'poplist_item2'
FROM     DUAL
UNION
SELECT  'poplist_item3'
FROM     DUAL

4. Create a New Page
Right click on PopListDemo > New > Web Tier > OA Components > Page
Name -- poplistdemoPG
Package -- prajkumar.oracle.apps.fnd.poplistdemo.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 -- prajkumar.oracle.apps.fnd.poplistdemo.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 -- prajkumar.oracle.apps.fnd.poplistdemo.server.poplistdemoVO
Picklist Display Attribute – poplist_items (Name of Attribute in  Your VO)
Picklist Value Attribute -- poplist_items
CSS Class – OraFieldText
Prompt – My PopList

10. Congratulation you have successfully finished. Run Your page and Test Your Work




No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...