错误描述：
描述
————————————————————————-
应用对象程序库: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDGSCST module: 统计数据收集模式
————————————————————————-
当前的系统时间为 02-04-2020 00:01:15
————————————————————————-
Starts**02-04-2020 00:01:15
*Ends*02-04-2020 00:46:07
ORA-0000: normal, successful completion
————————————————————————-
FND_FILE 中日志消息开始
————————————————————————-
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 60 degree = 32 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_MAPORA-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***
————————————————————————-
FND_FILE 中日志消息结束
————————————————————————-
成功地重新提交具有请求编号 532437 的并发程序 FNDGSCST，以在 02-05-2020 00:01:01 启动。 (ROUTINE=AFPSRS)
————————————————————————-
正在执行请求完成选项…
Output file size:
0
已完成执行请求完成选项。
————————————————————————-
此请求发布的例外：
Concurrent Request for “统计数据收集模式” has completed with error.
————————————————————————-
已完成并发请求
当前的系统时间为 02-04-2020 00:46:08
解决方案：
参考文件：11i – 12 Gather Schema Statistics fails with Ora-20001 errors after 11G database Upgrade (Doc ID 781813.1)
具体操作：
通过以下命令查询出有2条及以上条数的记录，
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 = ‘&TABLE_NAME’
and column_name = ‘&COLUMN_NAME’
and rownum=1;
— Use following SQL to delete obsoleted rows
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
);
commit;
特别说明：日志中只报了3个表的错误，实际上如果只处理这3个表的问题，依然不能正常完成请求，需要将所有大于等于2的条数的数据删除。