Simple SQL script for Decoding Siebel Audit Trail Data

Simple SQL script to decode siebel audit trail data using SQL:

==============================================================

We have implemented a simple method to decode the Siebel 8.0 audit data into old structure.  Basically it is a simple sql script and it gives the output in following format.  Try it and let me know if it works for you.

Output Data Format:

TBL_NAME, RECORD_ID, FIELD_NAME, OLD_VALUE, NEW_VALUE

Here is the script:

create table temp_aud1 as

    select

        aud.operation_cd,

        aud.operation_dt,

        aud.tbl_name,

        aud.record_id,

        replace(translate(SUBSTR(DBMS_LOB.SUBSTR (audit_log), DBMS_LOB.INSTR( audit_log, '2*C')+4, DBMS_LOB.INSTR( audit_log, '2*N')- (DBMS_LOB.INSTR( audit_log, '2*C')+4)),'1234567890',' '),'*',',') Column_List,