ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt

PROBLEM:

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
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***


SOLUTION:

Run this query,you will see the locked table.


SQL> select owner, table_name, stattype_locked
from dba_tab_statistics
where stattype_locked is not null
and owner not in ('SYS');

OWNER TABLE_NAME STATTYPE_LOCKED
-----   ----------       ---------------
SYSTEM DEF$_AQCALL ALL
SYSTEM DEF$_AQERROR ALL
ODM DMS_QUEUE_TABLE ALL
SYSTEM TBLMIG_MSG_QTAB ALL
APPLSYS FND_SOA_JMS_IN ALL
APPLSYS FND_SOA_JMS_OUT ALL
APPLSYS FND_CP_GSM_IPC_AQTBL ALL

Then run dbms_stats.unlock_schema_stats api to unlock this table.


SQL > exec dbms_stats.unlock_schema_stats('APPLSYS');

Pray & Tray :)