EBS : Gather Schema Statistics failed with ORA-20001: invalid column name or duplicate

Error:

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
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:
Step 1: Identify duplicate rows

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

SQL> conn apps/apps
Connected.
SQL> select table_name, column_name, count(*) from FND_HISTOGRAM_COLS group by table_name, column_name having count(*) > 1;

  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

8 rows selected.

Step 2: Use above results on the following SQL to delete duplicates

delete from FND_HISTOGRAM_COLS where table_name = '&TABLE_NAME' and  column_name = '&COLUMN_NAME'and rownum=1;
commit;

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 = 'VAT_REPORT_BOX' and rownum=1;


Step 3 : Submit the Gather schema statistics again

Reference (Doc ID 781813.1)