R12: PA: "PRC: Update Project And Resource Base Summaries" Gives "APPLSYS"."FND_STATTAB" Is Too Old Error (Doc ID 2221103.1)

Last updated on JULY 25, 2023

Applies to:

Goal

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.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.