How to Create Oracle ADF View Object based on Multiple ADF Entity Objects

Before getting started on creating VO based on multiple EO's , we need to do some steps.

1) Create Department EO under model.entity package (for any help : How to create ADF Entity Objects )

NOTE : People who are news to this post can download the Sample ADF Model Application from here ADF Model Sample Application and then can start from this post ..

While you create DepartmentsEO there will be two associations created automatically
1)DeptMgrFkAssoc
2)EmpDeptFkAssoc

This will be created because at database table level these are the foreign keys set and ADF will automatically recognize and will be created.


Now we are going to create VO that is based on DepartmentsEO and EmployeesEO

Step 1 :

Right Click on Model.View Package and select New View Object

Step 2 :

Create View Object dialog will open up and give the Name as EmptoDeptVO and Next

 














Step 3 :

Shuttle EmployeesEO and then DepartmentsEO from Available area to the right side. At the bottom the corresponding association will be selected and shown for the EO being selected  at Selected area . Just click Next

Step 4 :

Shuttle all the attributes from available area to the Selected area and click Next .

Step 5 :

Just click Next .

Step 6 :

you can able to see the query that is formed out of two EO's we added .  you can edit the query by selecting expert from the Sql Mode drop down . Just click Next

Step 7 :

Click Next

Step 8 :

Just Click Next

Step 9:

Select Application Module check box and make sure the info u given is right as given in the screen shot.
Click Next and Next and Finish .

Now your VO is ready . You can start testing by running the AM ( How to Run AM Step 6  )

ADF Model Sample Application Download

ADF Model Sample Application Model

Here is the link to download : ADF Model Sample Application Download

This zip file contains the sample ADF Model Application zip file which has all the elements described in the below chapters
 
Creating Entity Objects
Creating View Objects
Creating and Testing AM
Getting started with ADF 

privacy policy

This blog uses third-party advertising companies to serve ads when visiting this site. These third parties may collect and use information (but not your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, you can visit Google's Advertising and Privacy page.

If you wish to opt out of Advertising companies tracking and tailoring advertisements to your surfing patterns you may do so at Network Advertising Initiative.

Google uses the Doubleclick DART cookie to serve ads across it's Adsense network and you can get further information regarding the DART cookie at Doubleclick as well as opt out options at Google's Privacy Center

Privacy

I respect your privacy and I am committed to safeguarding your privacy while online at this site www.howtolearnadf.blogspot.in. The following discloses how I gather and disseminate information for this Blog.

RSS Feeds and Email Updates

If a user wishes to subscribe to my RSS Feeds or Email Updates (powered by Feedburner), I ask for contact information such as name and email address. Users may opt-out of these communications at any time. Your personal information will never be sold or given to a third party. (You will never be spammed by me - ever)

Log Files and Stats

Like most blogging platforms I use log files, in this case Statcounter , Icerocket tracker(invisible to users). This stores information such as internet protocol (IP) addresses, browser type, internet service provider (ISP), referring, exit and visited pages, platform used, date/time stamp, track user’s movement in the whole, and gather broad demographic information for aggregate use. IP addresses etc. are not linked to personally identifiable information.

Cookies

A cookie is a piece of data stored on the user’s computer tied to information about the user. This blog doesn't use cookies. However, some of my business partners use cookies on this site (for example - advertisers). I can't access or control these cookies once the advertisers have set them.

Links

This Blog contains links to other sites. Please be aware that I am not responsible for the privacy practices of these other sites. I suggest my users to be aware of this when they leave this blog and to read the privacy statements of each and every site that collects personally identifiable information. This privacy statement applies solely to information collected by this Blog.

Advertisers

I use outside ad companies to display ads on this blog. These ads may contain cookies and are collected by the advertising companies and I do not have access to this information. I work with the following advertising companies: Google Adsense. Please check the advertiser’s websites for respective privacy policies.

Contact Information

If you have any questions or concerns please contact blog Administrator at anantha.m.venu@gmail.com