After having received
some requests from Oracle EBS newbies, I have decided to do some video
tutorials to explain how screens can be built in OA Framework. For this
purpose, I will build a simple case study[Person Maintenance Screen].
To begin with, I will create a simple page in OA Framework, and in following sessions, I will add additional Functionality[creation/changes] to the same page.
To begin with, I will create a simple page in OA Framework, and in following sessions, I will add additional Functionality[creation/changes] to the same page.
Welcome
to the first Audio-Video tutorial in this series.
Objective :- To create a working page in OA Framework, without writing a single line of code in java.
Step 1 Create a table and insert sample data[3 records] for this demo.
Objective :- To create a working page in OA Framework, without writing a single line of code in java.
Step 1 Create a table and insert sample data[3 records] for this demo.
The above Step 1 will do the below:-
1.
Creates
a table named xx_person_details to capture Person Details
2.
Create
a API to help insert records in this table
3.
Inserts three records into table
xx_person_details
4.
In jDeveloper, create an OA Workspace and
default Project for this OA Framework tutorial
(
PERSON_ID NUMBER NOT NULL
,FIRST_NAME VARCHAR2(50)
,LAST_NAME VARCHAR2(50)
,EMAIL VARCHAR2(100)
,student_flag VARCHAR2(1)
,name_of_university VARCHAR2(100)
,last_update_date DATE
,last_update_login INTEGER
,last_updated_by INTEGER
,creation_date DATE
,created_by INTEGER
) ;
CREATE OR REPLACE PROCEDURE xx_insert_person_prc(p_person_rec IN
OUT xx_person_details%ROWTYPE) IS
BEGIN
SELECT per_people_s.NEXTVAL
INTO p_person_rec.person_id
FROM dual;
p_person_rec.last_update_date := SYSDATE;
p_person_rec.creation_date := SYSDATE;
p_person_rec.last_update_login := -1;
p_person_rec.last_updated_by := 71690;
p_person_rec.created_by := 71690;
INSERT INTO xx_person_details
VALUES p_person_rec;
END xx_insert_person_prc;
/
BEGIN
SELECT per_people_s.NEXTVAL
INTO p_person_rec.person_id
FROM dual;
p_person_rec.last_update_date := SYSDATE;
p_person_rec.creation_date := SYSDATE;
p_person_rec.last_update_login := -1;
p_person_rec.last_updated_by := 71690;
p_person_rec.created_by := 71690;
INSERT INTO xx_person_details
VALUES p_person_rec;
END xx_insert_person_prc;
/
DECLARE
l_person_rec xx_person_details%ROWTYPE;
BEGIN
l_person_rec.first_name := 'Anil';
l_person_rec.last_name := 'Passi';
l_person_rec.email := 'passi.anil@gmail.com';
l_person_rec.student_flag := 'N';
xx_insert_person_prc(l_person_rec);
l_person_rec.first_name := 'Tom';
l_person_rec.last_name := 'Kumar';
l_person_rec.email := 'tom.kumar@gmail.com';
xx_insert_person_prc(l_person_rec);
l_person_rec.first_name := 'Mark';
l_person_rec.last_name := 'Kapoor';
l_person_rec.email := 'tom.kumar@gmail.com';
xx_insert_person_prc(l_person_rec);
commit;
END;
/
l_person_rec xx_person_details%ROWTYPE;
BEGIN
l_person_rec.first_name := 'Anil';
l_person_rec.last_name := 'Passi';
l_person_rec.email := 'passi.anil@gmail.com';
l_person_rec.student_flag := 'N';
xx_insert_person_prc(l_person_rec);
l_person_rec.first_name := 'Tom';
l_person_rec.last_name := 'Kumar';
l_person_rec.email := 'tom.kumar@gmail.com';
xx_insert_person_prc(l_person_rec);
l_person_rec.first_name := 'Mark';
l_person_rec.last_name := 'Kapoor';
l_person_rec.email := 'tom.kumar@gmail.com';
xx_insert_person_prc(l_person_rec);
commit;
END;
/
SELECT count(*)
FROM xx_person_details ;
commit;
FROM xx_person_details ;
commit;
New Project

Create OA Workspace..

File Name : OAFsem13.jws (
Workspace name )

File Name : OAFsem13.jpr (
Project name )
Default Package : tutorial13.oracle.apps.ak.xxperson13
-Next

-Next

DBC File Name : test40.dbc
User Name : ax07926
Password : erptest
Application Short Name : XXRM
Responsibility Key : XXRM_R1_YEDEK_PARCA

-OK

Step 2 Create the
required BC4J and java packages for this OA Framework Screen
This step will create
xxPersonDetailsEO
[ Entity Object ]
xxPersonDetailsVO [ View Object ]
xxPersonAM [ Application Module ]
Relation between view Object and AM, in effect creating an instance of the View Object.
Name of this view Object instance will be xxPersonDetailsVO1
xxPersonDetailsVO [ View Object ]
xxPersonAM [ Application Module ]
Relation between view Object and AM, in effect creating an instance of the View Object.
Name of this view Object instance will be xxPersonDetailsVO1
Add
Business Components

OAFsem13.jpr -> Right-> New Business Components Package

-Next

-Next

-Bitir

-Tamam

Tutorial13.oracle.apps.ak.xxperson13.schema.server
Business component created
Create New Business Component

OAFsem13.jpr -> Right ->New Business Components Package

-İleri

-Bitir

Tutorial13.oracle.apps.ak.xxperson13.server
Business component created..
Create New Business Component

OAFsem13.jpr -> New Business Components Package

-Next

-Bitir

Tutorial13.oracle.apps.ak.xxperson13.webui
Business component created..
Create
Entity Object

Tutorial13.oracle.apps.ak.xxperson13.schema.server ->
Right -> New Entity Object...

-İleri

Name : XXPersonDetailsEO
Package : tutorial13.oracle.apps.ak.xxperson13.schema.server
Schema Object :
XX_PERSON_DETAILS_S
-ileri

-İleri

-İleri

-Yes

Validation Method
Create Method
-İleri

-İleri

-Bitir

Entity Object Created..
Create View Object..

XXPersonDetailsEO -> Right -> New Default View Object

View Object Created

XXPersonDetailsEOView -> Right -> Move package

Tutorial13.oracle.apps.ak.xxperson13.server

XXPersonDetailsEOView moved to tutorial13.oracle.apps.ak.xxperson13.server

XXPersonDetailsEOView -> Right ->
Rename XXPersonDetailsEOView

View Object name changed..
Create Application Module

Tutorial13.oracle.apps.ak.xxperson13.server -> Right
-> New Application Module

-Next

Name : XXPersonAM
-Next

-Next

-Next

-Next

-Bitir

Application Module Created

OAFsem13.jpr -> Right ->
New

OA Components -> Page
Tamam

Name : XXPersonMainPG
Package : tutorial13.oracle.apps.ak.xxperson13.webui
Tamam

XXPersonMainPG created
region1 -> Properties
ID : MainRN

AM definition
:tutorial13.oracle.apps.ak.xxperson13.server.XXPersonAM

Window Title : Main Person Page for Search

Title : Main Person Page for Search

-Save

MainRN -> New ->
Region

region1 created..
region1 properties
ID : QueryRN

Region Style : query

Construction Mode : resultBasedSearch

Include Simple Panel : True

Include Views Panel : True

Include Advanced : True


QueryRN -> Right -> New -> Region Using Wizard

-İleri

Region Style : table

PersonId – FirstName – LastName – Email selected...
-İleri

Style : messageStyled
-İleri

-Bitir

QueryRN table created..
Personld Properties
Search Allowed : True

Sort Allowed : ascending

FirstName Properties
Search Allowed : True

LastName Properties
Search Allowed : True

-Save
-Rebuild
the Project
-Run the
Page