APEX

I'm using APEX Application Express 4.0.2.00.09.


I have created an Iterative Report using APEX wizard, later I have altered the database table of IR to have a new column to capture other data. Now I want to show this newly added column in IR. In order to achieve this, I have modified the source region(i.e. SQL query) of IR. But newly added column is not getting reflected in IR automatically when I run the page.

Can somebody help me to resolve this issue.

Please note that I'm able to view the newly added column if I use Actions -> Select Columns -> New Column. But I want to get this new column automatically in the IR and don't want to use Actions operation every time I run the page.

Thanks in advance.