Audit Configuration

Note: This section covers the soft-table implementation of auditing. There is a specialist Audit algorithm support on Business and Maintenance objects to add information to log entries attached to these objects. Refer to the Oracle Utilities SDK and online Administration documentation for a description of programmatic implementation of auditing.

Audit configuration for Oracle Utilities Application Framework is performed at the table level. Enable auditing on each table by navigating to the Administration menu then the Table menu option, and configuring the following field settings:

• Audit Table: You need to configure a database table to store the audit information. By default, the CI_AUDIT table can be used for this purpose. When using a custom table, make sure that the structure of this table is similar to CI_AUDIT to ensure compatibility.

• Audit Program: You must configure a class or program that will record and process the audit information. By default, several pre-built audit programs are available for use:

• com.splwg.base.domain.common.audit.DefaultTableAuditor – This is the default java-based audit class provided by the product. It audits any changes to fields configured to track auditing information.

• com.splwg.base.domain.common.audit.ModifiedTableAuditor – This is an alternative to the DefaultTableAuditor class. However, it does not audit inserts or deletions of empty string field data. For example, changes from null values to empty spaces or empty spaces to null values are not logged.

Note: It is possible to implement custom Audit handlers using the base classes as parent classes. Refer to the Oracle Utilities SDK documentation on how to extend the product.

• Audit conditions: A set of switches are configurable on each field you wish to include in auditing to determine the conditions of auditing. At least one of these switches must be enabled for auditing to be registered:

• Audit Delete Switch: Enable this switch to audit delete operations against this field.

• Audit Insert Switch: Enable this switch to audit insert operations against this field.

• Audit Update Switch: Enable this switch to audit update operations against this field.

To maintain the audit information, navigate to the Table menu option on the Administration menu and specify the table to enable auditing against.

Specify the Audit Table, Audit Program (and associated type) and configure the Audit Switches on the fields you wish to track.

Note: To enable Auditing on a running version of the product, the online data cache must be flushed, or the product restarted. Refer to the Server Administration Guide for more details.