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: 220.127.116.11.00 to 18.104.22.168.00 - Release: 4.1 to 11.1
Information in this document applies to any platform.
GoalSome 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.
SolutionOracle 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 22.214.171.124 is available as Service Fix 126.96.36.199.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