Reconciling database events to ticket numbers is a time consuming manual task that can be easily automated. The solution is to populate the client_id context variable that is a standard feature of the Oracle RDBMS. Once set, the Client_id (CLIENT_IDENTIFIER) is written to the Oracle audit logs for any auditing activity generated during that session. By having the ticket id within the audit logs, reconciliation can be easily automated.

Auditing, Oracle Database, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Business Intelligence (OBIEE), Oracle Audit Vault