EUL4 and EUL5 Invalid Views
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.