Technology Stack - EBS (MOSC)

MOSC Banner

EUL4 and EUL5 Invalid Views

edited Mar 26, 2014 12:00PM in Technology Stack - EBS (MOSC) 3 commentsAnswered

We currently have over 40 invalid EUL4 and EUL5 views.  At some point during the various upgrades of the apps, db, and disco, these objects became invalid.

EBSO 12.1.3

DB 11.2.0.3

Disco 11.1.1.7

Taking a single object to troubleshoot shows the following results:

Researched as follows:

How To Identify Which Scheduled Workbooks And User Are Associated With Which Database View / Result Set (Doc ID 747806.1)

Invalid object:

APPS EUL4_B100201100418Q1V1    VIEW


select owner, table_name from dba_tables

where table_name like 'EUL4_B100201100418Q1%';

APPS    EUL4_B100201100418Q1R1

APPS    EUL4_B100201100418Q1R10

Shows 50 more associated tables to this object but will not paste here to save space.

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