Apps To Fusion

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

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

< Prev		Next >