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.


  • October 14, 2015 | 17 views