0 Replies Latest reply on Jan 20, 2016 7:14 PM by Joseph Meier

    Invalid TRIGGER APPS.ENG_LIFECYCLE_STATUSES_F1 - help compiling

    Joseph Meier

      I am still trying to get to 12.2.5 for over a month. Today I have made progress but now am stuck with an invalid trigger that I cannot seem to recompile. Here is the error:

       

      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> alter trigger APPS.ENG_LIFECYCLE_STATUSES_F1 compile;

      Warning: Trigger altered with compilation errors.

      SQL> show error
      Errors for TRIGGER APPS.ENG_LIFECYCLE_STATUSES_F1:

      LINE/COL ERROR
      -------- -----------------------------------------------------------------
      26/8  PL/SQL: SQL Statement ignored
      30/17  PL/SQL: ORA-00904: "EEC"."COMPLETION_DATE": invalid identifier

       

      I am doing this because the following error presents itself in the adwork logs upon patch application failure

       

      BEGIN AD_ZD_TABLE.APPLY('ENG_LIFECYCLE_STATUSES_F1'); END;

      *
      ERROR at line 1:
      ORA-20001: Cannot apply invalid crossedition trigger: ENG_LIFECYCLE_STATUSES_F1
      ORA-06512: at "APPS.AD_ZD", line 26
      ORA-06512: at "APPS.AD_ZD_TABLE", line 19
      ORA-06512: at "APPS.AD_ZD_TABLE", line 1683
      ORA-06512: at line 1

       

      Any advice would be greatly appreciated.