Develop Cascade Lookup in OIM 11gR2 PS3 without writing java code

Cascade lookup is a drop down fields (e.g. Country ->State ->City) by building parent-child relationships between columns so that values in the child field get filtered or scoped according to what was selected in the parent field, thus narrowing down your choices.

Starting from OIM 11gR2 PS2, oracle incorporated the cascade lookup features inside the for designer. Now developing cascade lookup in Application Instance for is very easy and no java code and managed bean is required to write. Below are the steps to develop the a cascade lookup in Application instance form.

1. Login to OIM sysadmin console.
2. Create a sandbox and activate the same.

      3. Go to form designer and search for the form where you need to add a cascade lookup.

4. Open the form and click on the New button to add a new field

5. Select the field type lookup and click Ok

6. In the Field details provide the display name of the field and create a new lookup (You can also use existing lookup)

7. Once done with the field details click on Save and Close

8. You can see the new lookup field gets created into the Application form. This lookup field we will be using as parent lookup.

9. Now we will be creating the dependent lookup. Similar to the parent lookup, follow the step 4, 5, 6

10. Once the lookup creating is done, click the check box named “Constrain list by parent field value selection”. Select the parent lookup created before.

11. Now click on the “Value Map” icon and map the parent data with dependent value, like below:

    

Select the parent data from left panel and shuttle all the corresponding dependent values from “Available Lookups” to “Selected Lookups”

Here in the example I had chosen Parent data as India (country) and all the corresponding cities Bangalore, Kolkata and Pune as dependent values.

Do the same for Other parent data.

12. Once the mapping is done click one the “Save and Close” button to save the field details

13. Now you can see both the lookup fields are now created. Now click on the “Regenerate View” to regenerate the form view in Application Instance during runtime.

14. Once all are done, take an export of the sandbox and publish the same.

15. Now Login to OIM Identity console

16. .  Create a new Sandbox and Activate the same.

17. Go to the Catalog and search for the Application Instance for any user

18. Add the Application to cart and click Next.

19. In the Cart Details page open the application form, and you can see both the lookup field are now added to for. This will still not work, until you made a small changes related to partial trigger.

20. Now click on the Customize Button

21. Go the Structure view and select the “Parent Lookup” field

22. From the Web Composer window (Right Panel) right click on the Parent Lookup component and click on Edit.

23. From the edit window just copy the Id value

24. Now close this window and right click on the Dependent Component and click on Edit

25. In the Edit window paste the copied value to the Partial Triggers field

26. Save the changes and Close the customize window.

27. Now Take an export the sandbox and Publish the same.

28. Now do a little testing. Open the catalog and select the Application Instance (For which the lookup fields are added)

29. Add the Application Instance to cart.

30. In the cart Item details Go to the Application form.

31. Now select some value from Parent Lookup field, and you will be able to see the Dependent lookup has been populated with corresponding dependent values.

Thank You!!!!!!!!!!!!!!!!

1