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.
Tags:Auditing, Oracle Database, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Business Intelligence (OBIEE), Oracle Audit Vault