Search This Blog

Saturday, September 3, 2011

OA Framework Tutorial 01






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.

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.

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

create table xx_person_details
(
 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;
/



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;
/

SELECT count(*)
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
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