H System Maintenance Tasks

You can run system processes to maintain and cleanup all runtime artifacts, such as the Process tables, Staging tables or Inbox / Outbox folders. Often the tables and folders contain vast amounts of data, which you may no longer need. With the System Maintenance Tasks feature, you can purge standard tables and folder by scheduling system processes and executing them.

Note:

All applications not assigned to a folder are purged when a single application is selected for a purge. The default application folder is generic and the purge script focuses on the folder in which the selected application resides. In this case if you want to prevent an application from being purged, save it to an independent folder

To facilitate the use of the Purge Scripts, Oracle Hyperion Financial Data Quality Management, Enterprise Edition provides the following:

• A set of custom scripts is shipped to the bin/system directory.

  The scripts include:

  • Maintain Application Folder

  • Maintain Process Table

  • Maintain EBS GL Balances Table

  • Maintain PeopleSoft Ledger Table

  • Maintain FDMEE Data Tables

• Scripts are registered as system scripts in script registration.

• Script are registered as part of installation with QUERYID = 0 and APPLICATIONID = 0.

• The script group "System" is created and system scripts are assigned to it.

• Script execution displays system scripts when the user has access irrespective of the target application in the POV.

• You can run purge scripts from the Script Execution screen.

• The ODI process executes the scripts from the bin/system dir instead of the data/scripts/custom directory.