Search Page OAF

1- Create a new workspace (MatloobSearchWS)

2- Create a new project (MatloobSearchPRJ)
     Package = MatloobSearch.oracle.apps.po.webui

3- Create Application Module (AM) (MatloobSearchAM)
     Package = MatloobSearch.oracle.apps.po.server

4- Enable passivation
     Right Click on MatloobSearchAM > Edit MatloobSearchAM > Custom Properties
     Name – RETENTION_LEVEL
     Value – MANAGE_STATE
     Click add > Apply > OK

5- Create Test Table and insert data some data in it (For Testing Purpose)

CREATE TABLE xx_search_demo
(    -- --------------------
     -- Data Columns
     -- --------------------
     column1                  VARCHAR2(100),
     column2                  VARCHAR2(100),
     -- --------------------
     -- Who Columns
     -- --------------------
     last_update_date    DATE         NOT NULL,
     last_updated_by     NUMBER   NOT NULL,
     creation_date          DATE         NOT NULL,
     created_by               NUMBER   NOT NULL,
     last_update_login    NUMBER
);

INSERT INTO xx_search_demo VALUES ('val1', 'val2', SYSDATE, 0, SYSDATE, 0, 0); 

INSERT INTO xx_search_demo VALUES ('val1', 'val2', SYSDATE, 0, SYSDATE, 0, 0); 

INSERT INTO xx_search_demo VALUES ('val3', 'val4', SYSDATE, 0, SYSDATE, 0, 0); 

INSERT INTO xx_search_demo VALUES ('val5', 'val6', SYSDATE, 0, SYSDATE, 0, 0);

commit;

6- Create Entity Object (EO)

    Name of EO  MatloobSearchEO

    Package   MatloobSearch.oracle.apps.schema.server

    Database Objects -- XX_SEARCH_DEMO

7- Create View Object (VO)

    Name of VO (MatloobSearchVO) 

    Package   MatloobSearch.oracle.apps.server

    In Step2 in Entity Page select MatloobSearchEO and shuttle them to selected list

    In Step3 in Attributes Window select columns Column1, Column2 and shuttle them to selected     list

    In Java page Select Generate Java file for View Object Class: MatloobSearchVOImpl      and Generate Java       File for View Row Class: MatloobSearchVORowImpl

8- Add Your View Object to Root UI Application Module

Select Right click on MatloobSearchAM > Edit MatloobSearchAM > Data Model >

Select MatloobSearchVO and shuttle to Data Model list

9- Create a new page & named (MatloobSearchPG) and set some of its basic attributes.

     Package =  MatloobSearch.oracle.apps.po.webui

    ID -- PageLayoutRN

    Region Style -- PageLayout

    AM Definition -- MatloobSearch.oracle.apps.po.server.MatloobSearchAM

    Window Title -- Search Page Window

    Title -- Search Page

    Auto Footer -- True

10 -1 Add a Query Bean to Your Page

Right click on PageLayoutRN > New > Region

Select new region region1 and set following properties

ID – QueryRN

Region Style – query

Construction Mode – resultBasedSearch

Include Simple Panel – True

Include Views Panel – True

Include Advanced Panel – True

11- Add a Result Data Table to your QueryRN

Select QueryRN right click > New > Region using Wizard

In BC4J Objects page, Select your SearchAM and then select your MatloobSearchVO1

Note – DO NOT select Use this as Application Module Definition for this region checkbox

In Region Properties page, set Region ID value to ResultsTable and Region Style to table

In view Attributes page, select attributes from Available View Attributes list and shuttle them to

Selected View Atributes list:

Column1

Column2

In Region Items Page, you can set ID, Style and Attributes Set. Currently we are going to set only Style as messageStyledText

12-  Set and verify Your Results Table Region Properties

ID – ResultsTable

Region Style – table

AM – Please Donot put any AM

Rendered – True

Records Displayed – 10

Width – 100%

User Personalization – True

13- Set or Verify Column1 Item Properties

Search Allowed -- True

Sort Allowed – ascending

Initial Sort Seqence – first

Selective Search Criteria – True

User Personalization – True

14- Set or Verify Column2 Item Properties

Search Allowed – True

Sort Allowed -- ascending

Selective Search Criteria – True

User Personalization – True

Test & Cheers.