This discussion is archived
4 Replies Latest reply: Feb 6, 2013 8:52 PM by 953987 RSS

ORA-20001 during GATHER_SCHEMA_STATS

953987 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points