Why Would Siebel Audit Trail S_AUDIT_ITEM Table Have Rows with ROW_ID = X ?
Last updated on AUGUST 28, 2017
Applies to:Siebel CRM - Version 8.0  and later
Information in this document applies to any platform.
***Checked for relevance on 04-Sep-2013***
***Checked for relevance on 28-Feb-2015***
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.
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...
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