Our apps version R12.2.5
DB version 220.127.116.11.0
Lets assume a existing column is revised and If there are any managed objects that may be referencing the original (now out-of-date) column,Lets say we have indexes or materialized views that reference the physical table columns. If these objects reference obsolete table columns, they need to be updated to refer to the latest revised columns. This step can be done automatically by Online Patching.
But If we have custom materialized views and custom indexes referencing the out-of-date column on this table,will these custom objects gets updated automatically? OR do we need to compile them manually?
The Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID: 1531121.1) should advise you which materialized views will have online patching issues like referencing packages etc. For sure, if you have a custom materialized view referencing an obsolete column, it will not be converted to use new columns. Were these materialized view created on 11i etc?