Have To Drop APPLSYS.FND_STATTAB After Every Gather Schema Stats, How to fix Permanently
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.
PRC: Refresh Project and Resource Base Summaries errors after "Gather schema statistics" is run weekly.
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
Also, tried to upgrade the table
But this happens every week, how can we fix this?
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