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

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.

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

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