R12: PA: "PRC: Update Project And Resource Base Summaries" Gives "APPLSYS"."FND_STATTAB" Is Too Old Error
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.
Users are getting the following error when executing "PRC: Update Project and Resource Base Summaries":
"Version of statistics table "APPLSYS"."FND_STATTAB" is too old. Please try upgrading it with dbms_stats.upgrade_stat_table"
This appears to happen after each time "Gather Schema Statistics" is executed on the database
The issue can be resolved with the fix provided in Oracle Support Note "Have To Drop APPLSYS.FND_STATTAB After Every Gather Schema Stats, How to fix Permanently (Doc ID 2023458.1)", which requires the execution of the following 3 steps
Please perform below as APPS user in SQL session:-
EXECUTE DBMS_STATS.drop_stat_table('APPLSYS', 'FND_STATTAB');
EXECUTE DBMS_STATS.create_stat_table('APPLSYS', 'FND_STATTAB');
EXECUTE DBMS_STATS.UPGRADE_STAT_TABLE('APPLSYS', 'FND_STATTAB');
- While this always successfully resolves the issue, we require "APPS" access and DBA support to execute this issue
Users would like a permanent solution that does not require the execution of the steps.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms