• Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

Fusion Apps Linkedin  |  Like us on Facebook  |  Get notified for our new articles  |  YouTube | Twitter | Linkedin Page | 


User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

Now that you have DB schema and JDeveloper setup, you are ready to build and test your first service layer. It will take just 10 minutest to build these objects and test them with your database, all within JDeveloper. Make sure that the DB schema created earlier you is available and has all correck PK and FK defined and enabled in DB.

You can download this sample application if something goes wrong with steps.

Create New Project

  1. Launch JDeveloper and select Default Role.
  2. Create New Application and name it "FirstModel". Give appropriate source directory for this application.
  3. Select General Application from the list of templates. Click Next and Finish.
  4. Right click on project and  "Erase from the Disk". This is because we will create a model project below that gives all needed libraries by default.
  5. Select New : Project and choose ADF Model as template
  6. Name the project as "MyModel" and click next
  7. Give appropriate default package like "apps2fusion.articles.model"

Create ADFbc using wizards

  1. Select New : Business Components : ADF Business Components : Business Components from Tables
  2. Click green "+" icon next to connections drop down to define a new DB connection using which you will create ADFbc. Use the DB shcema that you created earlier.
  3. Once you click OK, you are on step 1 of 6. Notice that the packages in each step will default according to the preferences we have set.
  4. Step 1 : Entity Objects. Click Query button to fetch all objects from DB. Select EMP, DEPT, LOCATION and BONUS tables.
  5. Select one of the table and notice the Entity Name below. JDev defaults it to EO becuase we used EO as suffix. Change this where it makes sense like EmpEO to EmployeeEO and DeptEO to DepartmentEO.
  6. Step 2 : View Objects. Select all fourn EO and shuttle to right side. Note that the name of the VO is defaulted to VO.
  7. Step 3 : Read Only View Objects. Do not select anything. We will talk about this later.
  8. Step 4 : Application Module. Give it a name HumanResourceAM.
  9. Step 5 : Business Component Diagram. Select the checkbox and give it hame HRADFbcDiagram. This is similar to DB Schema diagram and explains your object model.
  10. Review what you are generating and click finish.
  11. Expand the packages in the application navigator. Notice that there are assoications and view links created between entities based on the FK defined in the DB.
  12. Notice that in the HumanResourceAM, VOs are added and child VOs are added via the view links between then. Default VLs are created based on associations.
  13. Association, View Link and the VO names in AM are not following standard. We will talk about refactor feature going forward that lets us change this.




Add comment

Security code

Search Trainings

Enquire For Training

Related Items


About Apps2Fusion

Apps2Fusion are passionate about training. Training is our core business and we have been doing this for many many years. We thrive to meet expectations of our trainees and we are Oracle Gold Partners. We work hard to advise trainees with right career paths. We have published various five star rated Oracle Press Books each was best sellers in its category. We have helped many and could help you as well.