Technology Stack - EBS (MOSC)

MOSC Banner

PRC: Update Project and Resource Base Summaries’ is erroring

edited Sep 6, 2018 5:03AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center