Oracle Application Framework

This article must be read, after you have read Design of Simple OA Framework Page to interact with Table.

Here we will see the non-programming steps[done by mouse clicks in jDeveloper] for this OA Framework exercise, to create a screen that interacts with table.

Create a table, as below.

CREATE TABLE xx_oaf_demo_simple_01

(

 person_id integer

,first_name varchar2(30)

,last_name varchar2(30)

,CREATION_DATE               DATE

,CREATED_BY                  NUMBER(15)

,LAST_UPDATE_DATE            DATE

,LAST_UPDATED_BY             NUMBER(15)

,LAST_UPDATE_LOGIN           NUMBER(15)

) ;

Note: Ensure that you have picked columns for Record History too.

Create a BC4J Package for our OA Framework exercise, which in this case is xx.oracle.apps.ak.demosimple01

You will be prompted to create an EO, but simply click on finish without selecting our table.

Rightclick on BC4J, to create new Entity Object

Name: XxOafDemoSimple01
Packae: xx.oracle.apps.ak.demosimple01
Schema Object: XX_OAF_DEMO_SIMPLE_01
DataBase Schema: APPS

Select our table in the field "Schema Object" as above. Keep clicking on next after having selected the table. In the last step, you can Select the checkbox that prompts to create a default ViewObject for this ViewObject.

A default view object named XxOafDemoSimple01View will be created.

Note: Note the default instance name of the VO is XxOafDemoSimple01View1

This name will be used when referencing the VO Programatically.

Now, lets create the page.

Lets call it simpleTablePG, and also create a region of style PageLayout. Call this region MainRegionRN

Name: simpleTablePG
Package: xx.oracle.apps.ak.demosimple01.webui

Right click on the region to create new Controller for that region. We call this controller demoSimpleTableCO

Package Name: xx.oracle.apps.ak.demosimple01.webui

Class Name: demoSimpleTableCO

Lets create a nested/child region[within MainRegionRN], but this time using Wizard.

Click on MainRegionRN
New
Region Using Wizard

In the wizard, select the AM and view object on which this region will be based.

Application Module: xx.oracle.apps.ak.demosimple01 .Demosimple01AM
Available View Usages: XxOafDemoSimple01View1

The wizard will create all the fields in the screen, for each column in ViewObject

You will need to set Displayed to No for the record history fields.

Region ID: XxOafDemoSimple01View1
Region Style: rowLayout

Create a Button, no screenshot needed here, simply use steps from HelloWorld example for doing this.

Not lets have a look at programming bits for this screen.

Please click this link to see the details of programming steps

Anil Passi

Add comment