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

MOSC Banner

Several Materialized Views become Invalid everyday on a Fresh 12.1.3 instance - Must Use ADADMIN

edited Aug 20, 2021 9:06AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓
My customer has recently completed the implementation of a new E-Business suite 12.1.3 instance. Database is release 11.1.0.7.

Every day, he notices that several Materialized Views (MV) have become invalid. He has to launch adadmin and recompile invalid objects. This validates the MVs but only until the next day.

Materialized Views of concern are:

OWNER        OBJECT_NAME                              OBJECT_TYPE          STATUS
------------ ---------------------------------------- -------------------- -------
APPS         OZF_EARNING_SUMMARY_MV                   MATERIALIZED VIEW    INVALID
APPS         MSC_PHUB_CATEGORIES_MV                   MATERIALIZED VIEW    INVALID
APPS         MSD_DEM_SCN_ENTRIES_MV                   MATERIALIZED VIEW    INVALID
APPS         OE_ITEMS_MV                              MATERIALIZED VIEW    INVALID
MSC          MSC_ITEM_HIERARCHY_MV                    MATERIALIZED VIEW    INVALID
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