Create List of Values - LOV in Oracle ADF

In this post i will continue to enhance my previous post's Employee Form and create my first List of Values (LOV) in Oracle ADF Form. Creation of LOV in ADF is as simple as in Oracle Forms. In this post i am going to create LOV for Department and Job entities. Do the following steps to create LOV in ADF.


1) Add Departments and Jobs Entities
2) Add View Objects for Departments and Jobs LOVs
3) Create LOVs
4) Finally Link LOVs to JSF Page

Right click on adf.demo.model.view in Model project and choose Re-factor than Rename the  adf.demo.model.view to adf.demo.mode.queries for good naming convention.

Adding Departments and Jobs Entities

Right clicking on adf.demo.model.entities package in Model project and choose New Entity Object to Add Departments Entity.



Enter Name as DeptLOV and Choose Schema object as DEPARTMENT


Choose All columns in attributes page and click Finish


Repeat the same step for Jobs entity

Adding View Objects for Departments and Jobs LOVs

Right click on adf.demo.model.queries package and Choose New View Object


Enter name as DeptLOV and Click Next


Select the DeptLOV entity and move to selected area. Uncheck the Updatable option also


Select all Attributes to Selected area


Choose Dept ID in Order by section by pressing EDIT button and Click Finish


Repeat same steps for Jobs LOV

Creating LOVs

Double click EmployeeVO in adf.demo.model.queries section.Select DepartmentId attribute in the attribute page and Click "+" green button at the bottom under List of Values section


Click the green + button with List Data Source. Select DeptLOV in Available Objects change the Name at the bottom to DeptLOVAcesssor and move it to View Accessors to Create LOV


Choose Dept in List Attribute Return Values will populate automatically


Go to UI Hints tab Leave the List type as Choice List . Move DeptName from Available to Selected Area. Choose Labeled Item(First of List)  at very bottom include No Selection..  and set it accordingly


Repeat Same Steps for JobId attribute

Your EmpView page should looks like this


Linking LOVs to JSF Page

Open employee.jspx page in View Controller Project. Delete JobsId and DepartmentId attribute by selection them in Structure Window


Refresh the DataControl page. Expand the Data Control, Select DepartmentsId attribute from EmpView and Drag and Drop it to FormLayout. Menu will appear select  ADF One Choice List from Single Selection


Repeat the same step for JobId and adjust entities accordingly on your AFD Form. Now Finally Right click and Choose Run. Your Page should looks like this on Runtime




Comments

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more