PRC: Update Project and Resource Base Summaries’ is erroring
We have upgraded the EBS R(12.2.4) database from 11.2.0.4 to 12.1.0.2 four months back and after two weeks of upgrade ,we notice the concurrent program"PRC: Update Project and Resource Base Summaries’ is erroring with below error,
“ORA-20002: Version of statistics table
"APPLSYS"."FND_STATTAB" is too old.
as per note id "Doc ID 2023458.1 " ,it suggested to perform below steps
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');
exec ad_zd_table.patch('APPLSYS','FND_STATTAB');
However since we had code freeze in place and we didn't wanted to drop the objects in PROD so we performed below steps and the issue got resolved however we are receiving the same error now after 3 months of upgrade and again we applied the below to fixed the issue.