0 Replies Latest reply on Oct 12, 2015 5:35 PM by user10088255

    MATERIALIZED VIEW LOG upgrade strategy 12.1.3 to 12.2.4




      O/S: OEL 6.5 64 bits


      Hi all,


      We have a Component "XXPA123 – PA Revenue Interface to GL" is using view XXPA123_VIEWA, which creates a "MATERIALIZED VIEW LOG" on PA_DRAFT_REVENUES_ALL.


      Below are the few issues which was noticed:-


      1. It references to ROWID column of PA_DRAFT_REVENUES_ALL.

      2. It doesn’t have a synonym in APPS.

      3. It is used in package "XXPA123_PKGA" and if we remove the schema the package will also be invalid.


      Can you please review and let us know the procedure on the strategy which should be used for retro-fitting as per R12.2.4.


      Thanks for your time and help.