Gather Schema Stats Fail With ORA-0001 "unique constraint (APPLSYS.FND_STATS_HIST_U1)

Dear All,

One of my friends faced this problem today when he was trying to run "GATHER SCHEMA STATS" concurrent program.

Oracle application : 11.5.10.2

Error:

Gather Schema Stats Fail With ORA-0001 "unique constraint (APPLSYS.FND_STATS_HIST_U1)

Reason:

Version of FND_STATS package changed , this is happen due to reported BUG. BUG 6264433

ORA-1 ERRORS ARE REPORTED FOR APPLSYS.FND_STATS_HIST_U1 DURING GATHERING STATS

Solution:

1. Take backup of FND_STATS_HIST

2. Truncate table FND_STATS_HIST

3. re-submit GATHER SCHEMA STATS program

Note: 

You do NOT need to truncate this table after each run of Gather Schema Statistics. Doing it once
will be enough, because each run of GSS will use a new request_id.

FND_STATS_HIST table stored old statistics that can be restored in case new statistics are not acceptable. Deleting data from this table should not cause any functional problems.