Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Issue with MVIEW MSD_DEM_OBI_DEMANTRA_MV after Online Patching Enablement patch: 13543062

edited Jun 5, 2017 10:38AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 50 commentsAnswered ✓

Running ADZDEXRPT.sql & ADZDPAUT.sql after applying "Online Patching Enablement patch: 13543062:R12.AD.C" patch shows

DOC>

DOC>  *************************************************************

DOC>  SECTION 3

DOC>  *************************************************************

DOC>  Failed Jobs with ERRORS, For complete error stack and DDL,

DOC>  Please check AD_ZD_DDL_HANDLER table for corresponding DDL_ID

DOC>

DOC>#

Phase                      DDL ID Status       SQL                                                Error

-------------------- ------------ ------------ -------------------------------------------------- --------------------------------------------------

UPGRADE_MVIEW               11500 ERROR        begin                                              ORA-00942: table or view does not exist

                                               APPS.ad_zd_mview.upgrade('APPS','MSD_DEM_OBI_DEMAN

                                               TRA_MV'); end;

DOC>

DOC>  **********************************************************************

DOC>  SECTION-6

DOC>  **********************************************************************

DOC>

DOC>  AUTO FIX: Materialized Views

DOC>      - Will convert with equivalent EXPANDED QUERY

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center