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.