(This is an excerpt from Lesson 14 "Oracle BPM and ADF (Part 2)" from Avio Consulting's new self-paced online Oracle BPM Developer Workshop training.)
The purpose of this post is to show how to populate an ADF form field's dropdown with values from a database table. Once an item in the list of values (LOV) is selected from the dropdown, this shows to have the selected item automatically populate a BPM process's data object variable.
ADF projects used in BPM applications are often a mix of BPM process variables as well as ADF view object data control attributes. This is necessary on Oracle BPM projects because the BPM process might only store only an ID and the ADF forms might subsequently use the ID to extract the detailed information from the database for the end user to view on the ADF form.