Oracle ADF: Generating Table from managed Bean

I am developing a web application using Oracle ADF. I have a bounded task flow in that i have a page fragment in that I have a table. I am generating this table from managed bean. The following is my table

enter image description here

I have pasted "#{pageFlowScope.tableUtilBean.tableList}" in value field of table in the property inspector. My table is successfully generated.

I have a method in a managed bean called generateTable(). The table will be generated after executing a query. Suppose the query result contains 10 records the table will have 10 rows.

My problem is suppose if the query result is having 100 records this method is executing 100 times and the query is executing 100 times. Due to this, It is taking too much time to generate the table. I need to make sure that this method gets executes only once.

Please help me. How do I achieve this.

Thanks in advance.

Solution

In your task flow try to create a Method Activity and make it default activity. This method action should call #{pageFlowScope.tableUtilBean.generateTable}, before fragment is loaded.