How To Extract the Data Audit and Task Audit records of an HFM application to a File
Posted by Priya Doyle, Last modified by Priya Doyle on 02 December 2010 09:07 AM
Applies to:Hyperion Financial Management - Version: 188.8.131.52.00 to 184.108.40.206.00 - Release: 4.1 to 11.1
Information in this document applies to any platform.
Some system administrators of Financial Management desire a method to archive / extract the information from the DATA_AUDIT and TASK_AUDIT database tables of an HFM application before truncating those tables.
Oracle provides a stand alone utility called HFMAuditExtractUtilitiy.exe to accomplish this task. As well as extracting the records of the two log tables, the utility can also be used to truncate the tables at the same time.
The utility comes with a Readme file which should be consulted for more detailed instructions on how it should be used.
The latest version of the utility which is compatible with all versions of HFM up to 220.127.116.11 is available as Service Fix 18.104.22.168.05 (Oracle Patch 8439656).
Please see also the following KM Note on a related subject:
Note 843568.1 - Failed to retrieve a list of applications using database provided when using DB2 and earlier versions of the utility