Have To Drop APPLSYS.FND_STATTAB After Every Gather Schema Stats, How to fix Permanently
(Doc ID 2023458.1)
Last updated on DECEMBER 28, 2020
Applies to:Oracle Project Planning and Control - Version 12.2 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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document