Have To Drop APPLSYS.FND_STATTAB After Every Gather Schema Stats, How to fix Permanently (Doc ID 2023458.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

PRC: Refresh Project and Resource Base Summaries errors after "Gather schema statistics" is run weekly.
ERROR:
     ORA-20002: Version Of Statistics Table APPLSYS.FND_STATTAB is too old.

After error the following is done
  1.TAKE backup of APPLSYS.FND_STATTAB
  2.drop table APPLSYS.FND_STATTAB
  3.exec dbms_stats.create_stat_table('APPLSYS','FND_STATTAB');

 Also, tried to upgrade the table
       "exec DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS','FND_STATTAB')"

 

But this happens every week, how can we fix this?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms