1 Reply Latest reply on Oct 3, 2019 5:24 PM by mdtaylor

    custom materialized views and custom indexes on a revised table-R12.2

    3510875

      Hi experts,

       

      Our apps version R12.2.5

      DB version 12.1.0.2.0

       

      Our concern:

       

      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?

       

      Thank you