My Oracle Support Banner

Purging Oracle Utilities Business Intelligence Workflow Audit Information (Doc ID 1371336.1)

Last updated on JUNE 22, 2022

Applies to:

Oracle Utilities Business Intelligence - Version 2.0.5 to DNU2.2.1
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.3.2 and later
Information in this document applies to any platform.

Goal

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

OUBI - Oracle Utilities Business Intelligence
OUASA - Oracle Utilities Advanced Spatial and Operational Analytics
OUAF/FW - Oracle Utilities Framework
OWB - Oracle Warehouse Builder

Oracle Utilities Business Intelligence utilizes Oracle Workflow when running Oracle Warehouse Builder Process flows to load extract files into the Data warehouse. Even if extract files are not present, records are created in Audit tables each time a process flow is run.

Depending on the frequency with which process flows are scheduled, these audit tables could grow to become unmanageable, and can cause upgrades or process flow changes to fail when being deployed.

A few of these audit tables include the run-time Oracle workflow audit tables, and can grow very large:

1. WF_ITEM_ATTRIBUTE_VALUES - This table stores the run-time values of the Item Attributes for a particular Process flow.

2. WF_ITEM_ACTIVITY_STATUSES - This table, along with the WF_ITEM_ACTIVITY_STATUSES_H, contain all of the activities executed by a specific occurrence of a Process flow.

3. WF_NOTIFICATION_ATTRIBUTES - This table contains the run-time values of all the Message Attributes for a specific Notification

In addition, Oracle Warehouse Builder also contains audit tables that can also grow very large if not purged periodically.


We recommend that customers immediately start running a set of purge SQL statements at least once a week, that will remove old audit records for completed loads from workflow and warehouse builder audit tables. For customers running Near-Real Time loads from Oracle Utilities Network Management, it will be recommended that this purge process be run once a day (or twice a day if the loads are being run more frequently than every 10 minutes).

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.