Start a conversation Sign in
Start a conversation
  1. Concentric Solutions Ltd
  2. Source Default Category
  3. Source Default Folder

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


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
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. GKontos

  2. Posted

Comments