R12: PA: "PRC: Update Project And Resource Base Summaries" Gives "APPLSYS"."FND_STATTAB" Is Too Old Error (Doc ID 2221103.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

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

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