Wednesday, 14 October 2015

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.


No comments:

Post a Comment