One of the requirements at my current project is to have one ADF table display data from different database tables. That is, depending on criteria entered by the user, the query behind the view object needs to change. All in all 12 different database tables are involved in this story. This requirement is based on functionally in the original (oracle forms) application. This forms application used the set_block_property built-in:

set_block_property('<blockName>, query_data_source_name, <datasource>);

I was able to reproduce this behavior in an ADF application. In this post I explain how I did this (more…)