Performance on Account Merge When Audit Trail is On (Doc ID 2086915.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.14 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On :  8.1.1.11.14 [IP2013] version, following is observed:

ACTUAL BEHAVIOR  
---------------

Upon analyzing the sql statements, customer indicated that the sql below is taking ~3 minutes.
UPDATE SIEBEL.S_SRV_REQ SET  MODIFICATION_NUM = MODIFICATION_NUM + 1,
      LAST_UPD = ?,
      LAST_UPD_BY = ?,
      DB_LAST_UPD_SRC = ?,
      DB_LAST_UPD = current utc timestamp
WHERE ROW_ID IN (SELECT ROW_ID FROM  SIEBEL.S_SRV_REQ1_FNX
   WHERE AF_INS_COMPANY_ID = ?
   )


EXPECTED BEHAVIOR
-----------------------
Account merge should take less time

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch eCommunications for hi-tech industry in Open UI
2. Perform a merge on Account

Result: When the auditing is on Account,  merge transactions are  taking  ~4 minutes whereas as it takes ~40 seconds without auditing on Service request.

Cause

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