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

MOSC Banner

Patch 14247039 - Causes three MRP Views to Become Invalid

edited Jul 26, 2013 3:41AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered
Hi,
After applying the main patch  VCP 12.1.3.8 (14247039) , there were 0 invalid objects.
After running the Concurrent Program 'Drop Collections Snapshot' for the snapshot AHL_SCH_MTLS_SN , the following 3 objects were listed in the list of invalid objects.

OBJECT_NAME                                                                                                                      OWNER                          OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------ -------------------
AHL_SN_SCH_MTLS                                                                                                                        APPS                           SYNONYM
MRP_AP_CMRO_WIP_COMP_DMD_V                                                                                                 APPS                           VIEW
MRP_AN_AHL_MTL_REQS_V                                                                                                            APPS                           VIEW
MRP_AP_AHL_MTL_REQS_V                                                                                                            APPS                           VIEW


We were able to compile "AHL_SN_SCH_MTLS " but the three views are still left. Kindly help.

These are the invalid views:

MRP_AP_CMRO_WIP_COMP_DMD_V
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