11i: After Applying the Patches Required for SEPA There are Four New Invalid Objects
Hi,
I have applied below SEPA patches successfully on Test instance. Invalid count before patch application is 119 and after patch application is 69 but I have noticed below 4 new Invalids after SEPA patch application.I compiled manually with alter command, but no luck.
So please check and provide the solution to validate below objects asap.
SQL> select BUG_NUMBER,CREATION_DATE from ad_bugs where bug_number IN('13434486','13510283','14274000','16569836');
BUG_NUMBER CREATION_DATE
------------------------------ ---------------
13434486 17-SEP-13
13510283 17-SEP-13
14274000 17-SEP-13
16569836 17-SEP-13
SQL>
===================================
========== Four new Invalid list =============
OBJECT_NAME OBJECT_TYPE OWNER STATUS
===============================================================================================
XXCEU_CUSTUPD SYNONYM) XXCEU INVALID - ( After patch(13510283) application it was invalid)
I have applied below SEPA patches successfully on Test instance. Invalid count before patch application is 119 and after patch application is 69 but I have noticed below 4 new Invalids after SEPA patch application.I compiled manually with alter command, but no luck.
So please check and provide the solution to validate below objects asap.
SQL> select BUG_NUMBER,CREATION_DATE from ad_bugs where bug_number IN('13434486','13510283','14274000','16569836');
BUG_NUMBER CREATION_DATE
------------------------------ ---------------
13434486 17-SEP-13
13510283 17-SEP-13
14274000 17-SEP-13
16569836 17-SEP-13
SQL>
===================================
========== Four new Invalid list =============
OBJECT_NAME OBJECT_TYPE OWNER STATUS
===============================================================================================
XXCEU_CUSTUPD SYNONYM) XXCEU INVALID - ( After patch(13510283) application it was invalid)
Tagged:
0