Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

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.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.