4 Replies Latest reply: Feb 6, 2013 10:52 PM by 953987 RSS

    ORA-20001 during GATHER_SCHEMA_STATS

    953987
      Hi All,

      I have upgraded the EBS database from 10.2.0 to 11.2.0.3. And I am getting below error when I do GATHER_SCHEMA_STATS from Apps.

      DB - 11.2.0.3
      EBS - 12.1.3
      OS - RHEL 5 - 64

      Error #1: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
      Error #2: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
      Error #3: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** I query


      Kindly suggest/help me what I can do here.


      Thanks,
      Asm