The most common cause of poor performance is stale or missing table statistics. Financial Management applications create new tables or can clear existing tables and reload or replace entire data sets on the fly. By default, Oracle 10g and 11g run nightly jobs to check for tables that need statistics to be updated. This may not be sufficient in some cases. The following activities are common end user activities where the DBA should be informed that schema statistics should be updated:
New HFM application created and loaded
Data in an existing Scenario is cleared and reloaded
New Scenario/Year is opened and loaded with data. This includes scenarios populated by Financial Management rules.
Financial Management application is copied using the Financial Management application Copy utility. More information on the Copy utility can be found here: https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=968956.1.
After a Scenario/Year has been loaded with the first month’s data, data loads to subsequent periods do not affect table statistics.