11.5.10.2 : patch 4369527.generated BOM invalids
Hi,
patch 4369527.generated BOM invalids
Applying of this patch has generated another set of invalid objects as below.
SQL> l
1 select owner,OBJECT_NAME,OBJECT_TYPE from dba_objects
2* where status='INVALID'
SQL> /
OWNER OBJECT_NAME OBJECT_TYPE
---------- ------------------------------ -------------------
APPS BOM_EXPLOSION_VIEW VIEW
APPS BOM_CONSOLIDATE_EXPLOSION_VIEW VIEW
the errors are :
SQL> alter view BOM_EXPLOSION_VIEW compile;
Warning: View altered with compilation errors.
SQL> show err
No errors.
SQL> select line,text from user_errors where name='BOM_EXPLOSION_VIEW';
LINE
----------
TEXT
--------------------------------------------------------------------------------
0
ORA-00942: table or view does not exist
SQL> alter view BOM_CONSOLIDATE_EXPLOSION_VIEW compile;