ADF Multi Select LOV

In this section, we described an example of creating ADF multi-select LOV 

  1. Create an Employee FORM
  2. Create a Region field and make it as LOV
  3. Create a Country field and make it as LOV
  4. The Country LOV values change automatically based on the Region Selection
  5. Test the result using AppModule

 

Create an ADF project

 

1. Open JDeveloper

2. Click File >> New >> Applications >> Fusion Web Application >> Click Ok

050116_0519_CreateLOVin1 Create ADF Multi Select LOV

3. Give an application name >> Click Next

050116_0519_CreateLOVin2 Create ADF Multi Select LOV

4. Input project names for MODEL

050116_0519_CreateLOVin3 Create ADF Multi Select LOV

5. Give a package name for MODEL

050116_0519_CreateLOVin4 Create ADF Multi Select LOV

6. Input Project Name for VIEW

050116_0519_CreateLOVin5 Create ADF Multi Select LOV

7. Give a package name for VIEW. Click Finish. The Projects will appear in the Project Explorer

050116_0519_CreateLOVin6 Create ADF Multi Select LOV

 

Create Entity & View Objects for table Country, Region and Employee

 

8. Right click on the MODEL >> Click New >> Search entity >> Choose Entity Object

050116_0519_CreateLOVin7 Create ADF Multi Select LOV

9. Database connection wizard appears on the screen if it not already configured , click the + icon to create an HR schema connection

050116_0519_CreateLOVin8 Create ADF Multi Select LOV

10. Input HR schema connection

050116_0519_CreateLOVin9 Create ADF Multi Select LOV

11. Click Ok

050116_0519_CreateLOVin10 Create ADF Multi Select LOV

12. Input Country in the Name >> Click Browse on Schema Object >> Query (HR) >> Choose Countries >> Click Ok

050116_0519_CreateLOVin11 Create ADF Multi Select LOV

050116_0519_CreateLOVin12 Create ADF Multi Select LOV

13. Click Next

050116_0519_CreateLOVin13 Create ADF Multi Select LOV

14. Click Next

050116_0519_CreateLOVin14 Create ADF Multi Select LOV

15. Click Next

050116_0519_CreateLOVin15 Create ADF Multi Select LOV

16. Click Next

050116_0519_CreateLOVin16 Create ADF Multi Select LOV

17. Check the checkbox General Default View Object >> Change the package name to model.view >> Enable the checkbox Application Module >> Click Next

050116_0519_CreateLOVin17 Create ADF Multi Select LOV

18. Click Next >> Click Finish

050116_0519_CreateLOVin18 Create ADF Multi Select LOV

19. Create Entity Objects for another two tables, i.e., Region & Employee (Follow the steps from 8 to 18 to create Entity & View Objects for Region & Employee, the only difference is in step 12, you need to choose the relevant tables Region & Employee )

20. The project structure is similar like below

050116_0519_CreateLOVin19 Create ADF Multi Select LOV

Create View Criteria for Country

21. Double click on the Country View Object >> Click Query >> Click Plus symbol on the View Criteria

050116_0519_CreateLOVin20 Create ADF Multi Select LOV

22. Click button Add Criteria >> Create criteria as shown below

050116_0519_CreateLOVin21 Create ADF Multi Select LOV

Add custom variable to Employee view

23. Open the employee view object >> Click Plus symbol >> Create two fields RegionName and CountryName as shown below

050116_0519_CreateLOVin22 Create ADF Multi Select LOV

24. Select each created field (RegionName & CountryName ) >> Click Edit

050116_0519_CreateLOVin23 Create ADF Multi Select LOV

25. Make the selection Always for both the fields

050116_0519_CreateLOVin24 Create ADF Multi Select LOV

24. Select the CountryName >> Click the + icon on the List Of Value as shown below

050116_0519_CreateLOVin25 Create ADF Multi Select LOV

25. Input a name >> Click the + icon near to the List Data Source

050116_0519_CreateLOVin26 Create ADF Multi Select LOV

26. Drag the Country from left  to the Right as shown below and Click Ok

050116_0519_CreateLOVin27 Create ADF Multi Select LOV

27. Choose CountryId in the List Attribute

050116_0519_CreateLOVin28 Create ADF Multi Select LOV

28. Click UI Hints tab >> Drag the CountryNamefrom left to the right and Click Ok.

050116_0519_CreateLOVin29 Create ADF Multi Select LOV

29. Now Select the RegionName >> Click the + icon on the List of Value as shown below

050116_0519_CreateLOVin30 Create ADF Multi Select LOV

30. Click + icon near to the List Data Source

050116_0519_CreateLOVin31 Create ADF Multi Select LOV

31. Drag RegionEOView from left  to the Right and Click Ok

050116_0519_CreateLOVin32 Create ADF Multi Select LOV

32. Choose RegionId in List Attribute

050116_0519_CreateLOVin33 Create ADF Multi Select LOV

33. Click UI Hints tab >> Drag RegionName from left to the Right and ClIck Ok

050116_0519_CreateLOVin34 Create ADF Multi Select LOV

34. Now Click on the View Accessor

050116_0519_CreateLOVin35 Create ADF Multi Select LOV

35. Select the CountryEOView and Click Edit

050116_0519_CreateLOVin36 Create ADF Multi Select LOV

36. Drag the CounryEOViewCriteria to the right and Input RegionName In the value column (Note, this is the field name of the Region column)

050116_0519_CreateLOVin37 Create ADF Multi Select LOV

37. Click Save All

38. Right click the AppModule and click Run

050116_0519_CreateLOVin38 Create ADF Multi Select LOV

39. Double click on the EmployeeVOView1 >> Choose a Region in the dropdown >> the Country column values will get modified based on the Region Selection

050116_0519_CreateLOVin39 Create ADF Multi Select LOV

govindan Create ADF Multi Select LOV
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan Create ADF Multi Select LOV
Connect me
By | 2016-08-23T17:18:51+00:00 May 1st, 2016|Categories: ADF|Tags: , , , , |0 Comments
Like us on Facebook.
Connect!