My Oracle Support Banner

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:

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:-

- 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.


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

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