ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001:

Error

+---------------------------------------------------------------------------+

Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDGSCST: Gather Schema Statistics

+---------------------------------------------------------------------------+

Current system time is 22-JUN-2015 05:08:57

+---------------------------------------------------------------------------+

**Starts**22-JUN-2015 05:08:57

**Ends**22-JUN-2015 05:33:27

ORA-0000: normal, successful completion

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

In GATHER_SCHEMA_STATS , schema_name= ALL percent= degree = 8 internal_flag= NOBACKUP

stats on table AQ$_WF_CONTROL_P 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***

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

No completion options were requested.

Output file size:

0

+---------------------------------------------------------------------------+

Concurrent request completed

Current system time is 22-JUN-2015 05:33:27

+---------------------------------------------------------------------------+

Solution:


create table FND_HISTOGRAM_COLS_BKP as select * from FND_HISTOGRAM_COLS ;

select * from FND_HISTOGRAM_COLS_BKP ;


select table_name, column_name, count(*)
from FND_HISTOGRAM_COLS
group by table_name, column_name
having count(*) > 1;

delete from FND_HISTOGRAM_COLS
where table_name = 'JE_FR_DAS_010'
and column_name = 'TYPE_ENREG'
and rownum=1;


delete from FND_HISTOGRAM_COLS
where table_name = 'JE_FR_DAS_010_NEW'
and column_name = 'TYPE_ENREG'
and rownum=1;


delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_LINE_TYPE_MAP'
and column_name = 'SOURCE'
and rownum=1;

delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_LOGS'
and column_name = 'DECLARATION_TYPE_CODE'
and rownum=1;


delete from FND_HISTOGRAM_COLS
where table_name = 'JG_ZZ_SYS_FORMATS_ALL_B'
and column_name = 'JGZZ_EFT_TYPE'
and rownum=1;


delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_VAT_REP_RULES'
and column_name = 'LINE_TYPE'
and rownum=1;



delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_VAT_REP_RULES'
and column_name = 'SOURCE'
and rownum=1;



delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_VAT_REP_RULES'
and column_name = 'SOURCE'
and rownum=1;


delete from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_VAT_REP_RULES'
and column_name = 'VAT_REPORT_BOX'
and rownum=1;