Application Database Maintenance

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

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

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

Half-Yearly - Archive System Messages and truncate table.

Tip:

Set up alerts so that action can be taken if these tables grow beyond the recommended number of records (> 500,000). Note that large audit tables can have severe impact on Financial Management performance.