OAF Search page

  1.     Create a New Workspace and Project

   Right click Workspaces and click create new OAworkspace and name it as SrilathaSearch. Automatically a new OA          Project is also created. 

  

 Name the project : SearchDemo 

  Package                 : srilatha.oracle.apps.fnd.searchdemo

   

   2.     Create a New Application Module (AM)

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

     Name      : SearchAM
     Package : srilatha.oracle.apps.fnd.searchdemo.server

 3. 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); 

Now we have 4 records in our custom table

 4. Create a New Entity Object (EO)

Right click on SearchDemo > New > ADF Business Components > Entity Object

Name – SearchEO

Package -- srilatha.oracle.apps.fnd.searchdemo.schema.server

Database Objects -- XX_SEARCH_DEMO

Note – By default ROWID will be the primary key if we will not make any column to be primary key Check the Accessors, Create Method, Validation Method and Remove Method

  6. Create a New View Object (VO)

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

Name -- SearchVO

Package -- srilatha.oracle.apps.fnd.searchdemo.server

In Step2 in Entity Page select SearchEO 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: SearchVOImpl and Generate Java File for View Row Class: SearchVORowImpl

7. Add Your View Object to Root UI Application Module

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

Select SearchVO and shuttle to Data Model list    

8. Create a New Page

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

Name -- SearchPG

Package -- srilatha.oracle.apps.fnd.searchdemo.webui

9. Select the SearchPG and go to the strcuture pane where a default region has been created

10. Select region1 and set the following properties:

ID -- PageLayoutRN

Region Style -- PageLayout

AM Definition -- srilatha.oracle.apps.fnd.searchdemo.server.SearchAM

Window Title -- Search Page Window

Title -- Search Page

 11. 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

12. 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 SearchVO1

13. 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

 14. Set or Verify Column1 Item Properties

Search Allowed -- True

Sort Allowed – ascending

Initial Sort Seqence – first

Selective Search Criteria – True

User Personalization – True

15. Set or Verify Column2 Item Properties

Search Allowed – True

Sort Allowed -- ascending

Selective Search Criteria – True

User Personalization – True

Register OAF page in Oracle Applications

Copy all files from local machine to appropriate $JAVA_TOP directory 

 Find the server path where exactly to place the OAF project files into Oracle Applications server

Login to Putty

Execute cd $JAVA_TOP command to go to the JAVA TOP directory

Copy the classfiles from local machine to appropriate $JAVA_TOP director

Run the below import scripts for each and every Page and External Regions to redirect them to MDS(Meta Data Service) directory

java oracle.jrad.tools.xml.importer.XMLImporter  $JAVA_TOP/srilatha/oracle/apps/fnd/searchdemo/webui/SearchPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS = (PROTOCOL = tcp)(HOST = <name of HOST>)(PORT = =<port_number>))(CONNECT_DATA = (SID = SID_NAME>)))"

After importing we need bounce the server use the below  steps to bounce apache in R12

Release 12 (Run following command in UNIX)

Stop Server

adoacorectl.sh stop

 Start Server

adoacorectl.sh

Release 11 (Run following command in UNIX)

Stop Server

adapcctl.sh 

Start Server

adapcctl.sh start

Create form function with property "SSWA jsp function" and webhtml "OA.jsp?page=/srilatha/oracle/apps/fnd/webui/SearchPG "

 Add form function to “Purchasing SuperUser GUI” Menu

 Switch to the responsibility and open the page

Successfully created Search page and registered in oracle apps.