2 Replies Latest reply on Jan 18, 2017 5:17 PM by Mark Chappell - DXC

    Materialized views in 12.2

    User760935-Oracle

      Hi,

      I'm working on EBS 11.5.10 to R12.2.5 upgrade project for a client. With online patching in 12.2, it's not allowed to refer editioned objects(package functions) within non-editioned objects(materialized view). My client has many materialized views which has references of PL/SQL package functions in SQL. General guideline for this issue is to replace the function reference with equivalent SQL. Here, some of the functions have complex logic which can't be replaced with SQL. Is there any work around to continue using package functions inside materialized view definition.

       

      Thanks in advance.

      Suresh