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
No comments:
Post a Comment