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
);
( -- --------------------
-- 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);
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
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
Successfully
created Search page and registered in oracle apps.
No comments:
Post a Comment