Blog / Oracle Application Blog
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.
click Workspaces and click create new OAworkspace and name it as
SrilathaSearch. Automatically a new OA Project is also created.
Name the
project : SearchDemo
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)
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
);
( — ——————–
— 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);
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
custom table
4. Create a New Entity Object
(EO)
(EO)
Right click on
SearchDemo > New > ADF Business Components > Entity Object
SearchDemo > New > ADF Business Components > Entity Object
Name – SearchEO
Database Objects —
XX_SEARCH_DEMO
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
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)
New View Object (VO)
Right click on SearchDemo >
New > ADF Business Components > View Object
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
SearchEO and shuttle them to selected list
In Step3 in Attributes Window
select columns Column1, Column2 and shuttle them to selected list
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
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
UI Application Module
Select Right click on SearchAM
> Edit SearchAM > Data Model >
> Edit SearchAM > Data Model >
Select SearchVO and shuttle to
Data Model list
Data Model list
8. Create a New Page
Right click on SearchDemo
> New > Web Tier > OA Components > Page
> 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
Select the SearchPG and go to the strcuture pane where a default region has
been created
10. Select region1 and set the following
properties:
properties:
ID — PageLayoutRN
Region Style — PageLayout
AM Definition — srilatha.oracle.apps.fnd.searchdemo.server.SearchAM
Window Title — Search Page
Window
Window
Title — Search Page
11.
Add a Query Bean to Your Page
Right
click on PageLayoutRN > New > Region
click on PageLayoutRN > New > Region
Select
new region region1 and set following properties
new region region1 and set following properties
ID
– QueryRN
– QueryRN
Region
Style – query
Style – query
Construction
Mode – resultBasedSearch
Mode – resultBasedSearch
Include
Simple Panel – True
Simple Panel – True
Include
Views Panel – True
Views Panel – True
Include
Advanced Panel – True
Advanced Panel – True
12.
Add a Result Data Table to your QueryRN
Add a Result Data Table to your QueryRN
Select
QueryRN right click > New > Region using Wizard
QueryRN right click > New > Region using Wizard
In
BC4J Objects page, Select your SearchAM and then select your SearchVO1
BC4J Objects page, Select your SearchAM and then select your SearchVO1
13.
Set and verify Your Results Table Region Properties
Set and verify Your Results Table Region Properties
ID
– ResultsTable
– ResultsTable
Region
Style – table
Style – table
AM
– Please Donot put any AM
– Please Donot put any AM
Rendered
– True
– True
Records
Displayed – 10
Displayed – 10
Width
– 100%
– 100%
User
Personalization – True
Personalization – True
14. Set or Verify Column1 Item Properties
Search
Allowed — True
Allowed — True
Sort
Allowed – ascending
Allowed – ascending
Initial
Sort Seqence – first
Sort Seqence – first
Selective
Search Criteria – True
Search Criteria – True
User
Personalization – True
Personalization – True
15. Set or Verify Column2 Item Properties
Search
Allowed – True
Allowed – True
Sort
Allowed — ascending
Allowed — ascending
Selective
Search Criteria – True
Search Criteria – True
User
Personalization – True
Personalization – True
Register OAF page in Oracle Applications
Copy all files from local machine to appropriate $JAVA_TOP
directory
directory
Find the
server path where exactly to place the OAF project files into Oracle
Applications server
server path where exactly to place the OAF project files into Oracle
Applications server
Login
to Putty
to Putty
Execute
cd $JAVA_TOP command to go to the JAVA TOP directory
cd $JAVA_TOP command to go to the JAVA TOP directory
Copy
the classfiles from local machine to appropriate $JAVA_TOP director
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
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>)))”
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
importing we need bounce the server use the below steps to bounce apache in R12
Release 12 (Run following
command in UNIX)
command in UNIX)
Stop
Server
Server
adoacorectl.sh
stop
stop
Start
Server
Server
adoacorectl.sh
Release 11 (Run
following command in UNIX)
following command in UNIX)
Stop
Server
Server
adapcctl.sh
Start Server
adapcctl.sh
start
start
Create
form function with property “SSWA jsp function” and webhtml “OA.jsp?page=/srilatha/oracle/apps/fnd/webui/SearchPG
“
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.
created Search page and registered in oracle apps.
