There are scenarios where user wants to select multiple values from Input List of Values (LOV) component and store in DB column as comma separated or any other delimiter.
In ADF using Jdeveloper we can achieve this functionality but we need to customize standard things.
follow the below steps to do this:
1) Create an VO and attach LOV to an attribute. (for ex. i created a TempVo and having three attibutes: ID,Dept & Description and attached LOV to Dept which store ID and show department name on UI)
2) Now to convert LOV that supports multiple value selection, we need to modify Vo.xml for tht attribute on which LOV is applied. Select the attribute on which you defined the Lov and then change the CONTROLTYPE value to 'delimited_ids_choice'.
3) Go to List binding tag in the same Vo.xml file and change as below:
4) Next step is to build UI. Drag and drop the view from Data control on to page and modify the LOV attribute code in source file as below:
5) Now go to page definition and select List Binding and change as below (if there is no List Binding on page then create ot manually or add the code manually )
That's all run the page and select multiple value from LOV and store in DB.
4) Next step is to build UI. Drag and drop the view from Data control on to page and modify the LOV attribute code in source file as below:
Hi All,
ReplyDeleteAdding to this Post :
Remove below attribute from list binding of page definition (Step : 5)
SelectItemValueMode="ListObject"
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle ADF .
ReplyDeleteActually, I was looking for the same information on internet for
Oracle ADF Interview Questions and Answers/Tips and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
ReplyDeleteIam so thrilled because of finding your alluring website here.Actually i was searching for Oracle PPM Cloud.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle Fusion HCM.Thank you soo much.