Showing posts with label Tabular Form. Show all posts
Showing posts with label Tabular Form. Show all posts

Monday, December 17, 2012

Advisor misses column mapping for Tabular Form

If you create a tabular form based on a view or table you have to take care that the column mapping have to be updated.
In a short test where i created a view on a table i changed the name of the view after creating the tabular form.I got an error "ORA-00942" that table or view were missing.
I went through all processes and changed the view name, but i missed one column. Checking the Page with the APEX Advisor the failure in my column mapping was not found.
The problem can be found with this query:

select c.application_id
      ,c.page_id
      ,c.column_alias
      ,c.reference_table_name
      ,c.reference_column_name
from apex_application_page_rpt_cols c
left join user_tab_cols u on u.table_name = c.reference_table_name and
                             u.column_name = c.reference_column_name
where c.reference_table_name is not null and
      c.reference_column_name <> 'ROWID' and
      u.table_name is null


It would be nice to add this check to the advisor  @ APEX Team