Home » Archive

Articles Archive for December 2011

Configuration, Siebel SQLs & Database »

[29 Dec 2011 | 5 Comments | ]

In new versions of Siebel CRM application, Oracle has encoded the audit trail to store it in encoded format in Siebel, instead of Separate columns of New and Old values. Hence it is not possible to get those values by directly reading the S_AUDIT_ITEM table.
So, I have created a Oracle SQL Procedure which will help you decode the audit trail and store in a temporary table, just like it was earlier. Here, you would need to provide Table, Column for which you want to grab the audit trail. You can specify multiple …