My Oracle Support Banner

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

Last updated on APRIL 30, 2024

Applies to:

Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform. *** ***


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.

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...


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.