<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Related Items

Home arrow Technical Articles arrow Oracle Application Framework arrow OA Framework Table Based Scree Non Programming Steps
This website has now moved to http://apps2fusion.com

OA Framework Table Based Scree Non Programming Steps | Print |  E-mail
Written by Anil Passi   
Sunday, 25 February 2007
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_UPDATED_BY             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

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

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

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

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

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.

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

The above steps will produce the result as shown below.

Not lets have a look at programming bits for this screen.
Please click this link to see the details of programming steps

Comments (4)add
written by Anil Passi , March 06, 2007
Hi Ramesh

Wizard will not ask you for BC4J again.
It will simply ask you for the Application Module [AM].

Please select the same AM that you had attached to properties of MainRegionRN [under bc4j/AM Definition in property pallete]

written by Arun Reddy , August 29, 2007
Hi Anil,

Iam very new to this OAF technology.
Basically I'm Apps Techno Functional Consultant.
I want to learn OAF as Fusion is going to use OAF.
Can you please let me know what are the minimum prerequisities I need on my PC to pracitce the OAF articles posted on this website.
I have bit confusion about Fusion.I read some where that Fusion is going to use ADF.
Is ADF and OAF both are same?
Can you please clarify my doubts.

Arun Reddy
written by Anil Passi , August 30, 2007
Hi Arun

You need ideally at least 1GB RAM and connectivity to Database with APPS instance.

Fusion will use ADF, but the BC4J layer will remain[although will be enhanced]

In OAF we do a lot of programming, speficially in controllers. But inn ADF there will be a lot less programming required

Anil Passi
how to display rows in a table in different colors depending upon some particular attibute of view object?
written by avanindra , March 06, 2008
Hi anil,

I have stuck in a problem, I have to show some of the rows in a table in different color depending on one particular attribute's value of the view object which is associated with the table...Can you please answer me how to do that?
You must be logged in to a comment. Please register if you do not have an account yet.