0 Replies Latest reply on Jul 7, 2005 6:30 AM by 444182

    ORA-04063: package body "APPS.WFA_HTML" has errors

    444182
      Hi,
      being in OA 11i version, after migrating to OATM we can't access E-BUSINESS and we receive the error message which begins with :
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-04068: existing state of packages has been discarded
      ORA-04063: package body "APPS.WFA_HTML" has errors
      ORA-06508: PL/SQL: could not find program unit being called
      ORA-06512: at "APPS.ICX_PORTLET", line 466
      ORA-06512: at line 1
      ; (Could not lookup message because there is no database connection)
      at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:625)
      then we recompiled all APPS schema by adadmin and utlrp.sql.
      But the number of invalid object is always the same :
      COUNT(*) OWNER
      ---------- ------------------------------
      2614 APPS
      526 APPS_MRC
      88 CTXSYS
      1 INV
      3 MSC
      1 ONT
      1 OPS$ORAIPRDI
      2 PATROL34
      1 PERFSTAT

      9 rows selected.
      Many thanks in advance.