EPM 11.1.2 - HFM Database housekeeping

The following housekeeping practices are recommended when using Oracle / SQL Server databases with Financial Management:

· For HFM tables <appname>_DATA_AUDIT, <appname>_TASK_AUDIT and HFM_ERRORLOG, it is recommended to implement the following housekeeping best practices:

o    Quarterly - Business to review the Audit logs, archive and delete.

o    Half-Yearly - Archive System Messages and truncate table.


Tip: Put alerts in place so that action can be taken if these tables grow beyond the recommended number of records (> 500,000). Note large audit tables will have severe impact on HFM performance.


Post a Comment:
Comments are closed for this entry.