2 Replies Latest reply: Mar 29, 2013 10:49 AM by Rrademak-Oracle RSS

    Invalid objects in EBS R12.1.1 VIS

    Roderick Chen-Oracle
      I'v just installed EBS R12.1.1 VIS, having found invalid objects in its database that cannot be compiled by running rdbms/admin/utlrp.sql


      SQL> @?/rdbms/admin/utlrp.sql

      ......

      OBJECTS WITH ERRORS
      -------------------
      4

      ......

      ERRORS DURING RECOMPILATION
      ---------------------------
      4

      PL/SQL procedure successfully completed.

      Invoking Ultra Search Install/Upgrade validation procedure VALIDATE_WK
      Ultra Search VALIDATE_WK done with no error

      PL/SQL procedure successfully completed.


      SQL> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

      COUNT(*)
      ----------
      12


      SQL> SELECT owner, count(*) sum FROM dba_objects WHERE status <> 'VALID' group by owner;

      OWNER               SUM
      ------------------------------ ----------
      RE                    1
      CA                    2
      PUBLIC               4
      HERMAN               1
      APPS                    5
      FLOWS_010500          2

      6 rows selected.


      SQL> select * from sys.UTL_RECOMP_ERRORS;

      OBJ# ERROR_AT COMPILE_ERR
      ------------- ----------------------------------------------------- ---------------------------------------------------------------------------
      1006661     28-MAR-13 07.43.15.505723000 AM     "ORA-04045: errors during recompilation/revalidation of PUBLIC.WWV_FLOW_LIST_OF_VALUES_DATA
      ORA-00980: synonym translation is no longer valid"
      1006663     28-MAR-13 07.43.15.507741000 AM     "ORA-04045: errors during recompilation/revalidation of PUBLIC.WWV_FLOW_LISTS_OF_VALUES$
      ORA-00980: synonym translation is no longer valid"
      1006687     28-MAR-13 07.43.15.509455000 AM     "ORA-04045: errors during recompilation/revalidation of PUBLIC.WWV_FLOW_GENERIC
      ORA-00980: synonym translation is no longer valid"
      1006699     28-MAR-13 07.43.15.511259000 AM     "ORA-04045: errors during recompilation/revalidation of PUBLIC.WWV_FLOW_FIELD_TEMPLATES
      ORA-00980: synonym translation is no longer valid"

      Question:
      How to solve this? Can I just delete these invalid objects from SYS.DBA_OBJECTS ?