2 Replies Latest reply: Nov 19, 2012 3:30 PM by Hussein Sawwan-Oracle RSS

    Invalid Objects - Views and Packages - after upgrading ebs 12.1.1 to 12.1.3

    user558643
      Hello,

      I have just successfully upgraded ebs 11i to 12.1.1 and 12.1.1 to 12.1.3. There are about 50 invalid objects, mostly views of the apps schema that I have been unable to compile.

      OWNER OBJECT_TYPE COUNT(*)
      ----------- ----------------------- --------------
      APPS     PACKAGE BODY     2
      OWAPUB     PACKAGE BODY     3
      APPS     VIEW     44

      OWNER OBJECT TYPE STATUS
      -------- -------------------- ------------------- -------
      APPS CEBG_BANK_STATEMENTS VIEW INVALID
      APPS CEFG_BANK_STATEMENTS VIEW INVALID
      APPS CEBG_BANK_STATEMENT_ VIEW INVALID
      APPS CEFG_BANK_STATEMENT_ VIEW INVALID
      APPS GLFG_ACTUAL_BALANCES VIEW INVALID
      APPS GLFG_ACTUAL_JOURNAL_ VIEW INVALID
      APPS GLBG_ACTUAL_BALANCES VIEW INVALID
      APPS GLFG_ACTUAL_JOURNAL_ VIEW INVALID
      APPS GLBG_ACTUAL_JOURNAL_ VIEW INVALID
      APPS GLFG_BUDGET_BALANCES VIEW INVALID
      APPS GLBG_ACTUAL_JOURNAL_ VIEW INVALID
      APPS GLFG_BUDGET_JOURNAL_ VIEW INVALID
      APPS GLBG_BUDGET_BALANCES VIEW INVALID
      APPS GLFG_BUDGET_JOURNAL_ VIEW INVALID
      APPS GLBG_BUDGET_JOURNAL_ VIEW INVALID
      APPS GLBG_BUDGET_JOURNAL_ VIEW INVALID
      APPS GLFG_ENCUMBRANCE_BAL VIEW INVALID
      APPS GLFG_ENCUMB_JOURNAL_ VIEW INVALID
      APPS GLBG_ENCUMBRANCE_BAL VIEW INVALID
      APPS GLFG_ENCUMB_JOURNAL_ VIEW INVALID
      APPS GLBG_ENCUMB_JOURNAL_ VIEW INVALID
      APPS GLBG_ENCUMB_JOURNAL_ VIEW INVALID
      APPS GLFG_GL_AVERAGE_BALA VIEW INVALID
      APPS GLFG_GL_BUDGETS VIEW INVALID
      APPS GLFG_GL_BUDGET_ASSIG VIEW INVALID
      APPS GLBG_GL_AVERAGE_BALA VIEW INVALID
      APPS GLBG_GL_BUDGETS VIEW INVALID
      APPS GLFG_GL_BUDGET_ORGAN VIEW INVALID
      APPS GLBG_GL_BUDGET_ASSIG VIEW INVALID
      APPS GLBG_GL_BUDGET_ORGAN VIEW INVALID
      APPS GLFG_GL_STANDARD_BAL VIEW INVALID
      APPS GLFG_JOURNAL_BATCHES VIEW INVALID
      APPS GLBG_GL_STANDARD_BAL VIEW INVALID
      APPS GLBG_JOURNAL_BATCHES VIEW INVALID
      APPS GLFG_JOURNAL_ENTRIES VIEW INVALID
      APPS GLFG_JOURNAL_LINES VIEW INVALID
      APPS GLBG_JOURNAL_ENTRIES VIEW INVALID
      APPS GLBG_JOURNAL_LINES VIEW INVALID
      APPS OTFG_EXT_TRAINING_EV VIEW INVALID
      APPS PAFG_BUDGET_LINES VIEW INVALID
      APPS POBG_SUPPLIERS VIEW INVALID
      APPS POFG_SUPPLIERS VIEW INVALID
      APPS PSBBG_GL_ACCOUNT_HIE VIEW INVALID
      APPS PSBFG_GL_ACCOUNT_HIE VIEW INVALID
      OWAPUB OWA_UTIL PACKAGE BODY INVALID
      OWAPUB OWA_OPT_LOCK PACKAGE BODY INVALID
      OWAPUB DEBUG_CARTX PACKAGE BODY INVALID
      APPS ZPB_BUILD_METADATA PACKAGE BODY INVALID

      I have tried a manual recompilation but each has different errors and I am thinking that there might be some patches that may resolve many of them at once. For example

      SQL> alter package APPS.ZPB_BUILD_METADATA compile body;

      Warning: Package Body altered with compilation errors.

      SQL> show error
      Errors for PACKAGE BODY APPS.ZPB_BUILD_METADATA:

      LINE/COL ERROR
      -------- --------------------------------------------------------
      191/10 PL/SQL: Statement ignored
      191/10 PLS-00904: insufficient privilege to access object
      PUBLIC.CWM2_OLAP_TABLE_MAP

      194/10 PL/SQL: Statement ignored
      194/10 PLS-00904: insufficient privilege to access object
      PUBLIC.CWM2_OLAP_TABLE_MAP

      I have looked at some forum links but unable to match any to these errors.

      Thanks
      Mathias