EBS : Gather Schema Statistics Error - ORA-20001: invalid column name or duplicate columns/column

Error:

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: Refrence note ID 781813.1

SQL> select column_name, nvl(hsize,254) hsize
from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_LINE_TYPE_MAP'
order by column_name;  2    3    4

COLUMN_NAME                         HSIZE
------------------------------ ----------
SOURCE                                254
SOURCE                                254

SQL> select column_name, nvl(hsize,254) hsize
from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_LOGS'
order by column_name;  2    3    4

COLUMN_NAME                         HSIZE
------------------------------ ----------
DECLARATION_TYPE_CODE                 254
DECLARATION_TYPE_CODE                 254

SQL> select column_name, nvl(hsize,254) hsize
from FND_HISTOGRAM_COLS
where table_name = 'JE_BE_VAT_REP_RULES'
order by column_name;  2    3    4

COLUMN_NAME                         HSIZE
------------------------------ ----------
LINE_TYPE                             254
LINE_TYPE                             254
SOURCE                                254
SOURCE                                254
VAT_REPORT_BOX                        254
VAT_REPORT_BOX                        254

6 rows selected.

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

TABLE_NAME                     COLUMN_NAME                      COUNT(*)
------------------------------ ------------------------------ ----------
JE_FR_DAS_010                  TYPE_ENREG                              2
JE_FR_DAS_010_NEW              TYPE_ENREG                              2
JE_BE_LINE_TYPE_MAP            SOURCE                                  2
JE_BE_LOGS                     DECLARATION_TYPE_CODE                   2
JG_ZZ_SYS_FORMATS_ALL_B        JGZZ_EFT_TYPE                           2
JE_BE_VAT_REP_RULES            LINE_TYPE                               2
JE_BE_VAT_REP_RULES            SOURCE                                  2
JE_BE_VAT_REP_RULES            VAT_REPORT_BOX                          2

Run the following as APPS user queries and run the delete quries, commit  and re-run the Gather Schema Statistics Concurrent program:

select 'delete from FND_HISTOGRAM_COLS where table_name = '''||TABLE_NAME||''' and  column_name = '''||COLUMN_NAME||''' and rownum=1;' from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;

select 'delete from FND_HISTOGRAM_COLS where (table_name, column_name) in (select hc.table_name, hc.column_name from FND_HISTOGRAM_COLS hc , dba_tab_columns tc where hc.table_name  ='''||TABLE_NAME||''' and hc.table_name= tc.table_name (+) and hc.column_name = tc.column_name (+) and tc.column_name is null);' from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;

commit;