Knowledgebase: HFM
How To Extract the Data Audit and Task Audit records of an HFM application to a File
Posted by Priya Doyle on 07 December 2010 05:54 PM

How To Extract the Data Audit and Task Audit records of an HFM application to a File

 Modified 23-MAR-2010 

Applies to:

Hyperion Financial Management - Version: 4.1.0.0.00 to 11.1.1.3.00 - Release: 4.1 to 11.1
Information in this document applies to any platform.

Goal

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.


Solution

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 11.1.1.3 is available as Service Fix 11.1.1.2.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


(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: