My Oracle Support Banner

Siebel Audit Trail Log Extraction For ETL And Report Purposes (Doc ID 2440630.1)

Last updated on APRIL 14, 2020

Applies to:

Siebel CRM - Version 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14 [IP2014] version, Client Functionality

ACTUAL BEHAVIOR
---------------
Siebel Audit Trail log Extraction for ETL and report purposes

Hi Oracle,

We are trying to decode audit trial functionality into a custom table for reporting purposes. We need all the audit data to be decoded and write to an external systems to generate reports.

As suggested by Oracle, we're currently using a standard Business Service (CSSService) which has eScript code to extract Audit logs from Siebel. The eScript code uses "Audit Trail Item 2" BC based on the "CSSBCVAuditTrail" Class to fetch the records.

We also implemented Oracle recommendation of limits the number of records processed in the batch for which we Created a wrapper workflow which in turn calls 10 sub workflows to extract data for a given period.
 
However we still facing extreme slowness and performance impacts. Hence we would like to know the best practices already available to decode the audit trial data and also let us know if Oracle has developed any tool to decode the audit trail data? What is Oracle suggestion of audit trail data for reporting purposes?

Please find the technical details.

Business component : Audit Trail Item 2
Audit Trial Table : S_AUDIT_ITEM
  
Target Business Component : SIS Audit Trail 2
Target table : CX_AUDIT2

The development was based on the recommendations provided as part of another SR.


Changes

 

Cause

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
Symptoms
Changes
Cause
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.