Why Would Siebel Audit Trail S_AUDIT_ITEM Table Have Rows with ROW_ID = X ? (Doc ID 800473.1)

Last updated on FEBRUARY 22, 2016

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.
***Checked for relevance on 04-Sep-2013***
***Checked for relevance on 28-Feb-2015***

Goal

The standard database contains this trigger. Checked in installation and noticed this trigger is created in the database installation. There is a script called create_db_triggers.sql in the <Siebel_DB_Scripts>\MSSQL directory. 

Verified in installation logs and could confirm this script is called during the installation process (from upgwiz.log):

UpgradeLog UpgradeInfo 3 0000000245c90294:0 2007-02-07 11:59:47 Status Message (Executing SQL statements in file F:\Sia80\dbsrvr\mssql\create_db_triggers.sql ...)

Also checked some other databases (versions 7.5.x, 7.7.x, 7.8.2.x) and could not find it. This trigger has been introduced in version 8.0 and it is also defined in version 8.1.

create trigger S_AUDIT_ITEM_TRIG
on S_AUDIT_ITEM
for insert
as
update S_AUDIT_ITEM
set ROW_ID = ITEM_IDEN_NUM
where ROW_ID = 'X'
/


The UPDATE statement would set ROW_ID equals to ITEM_IDEN_NUM for a specific ROW_ID (equals to 'X'). In other words, this SQL statement would not update any row...

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms