My Oracle Support Banner

Performance Issue Due To Additional Query While Trying Open Application URL With Specific Record Row Id (Doc ID 2543794.1)

Last updated on OCTOBER 25, 2019

Applies to:

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

Symptoms

On : 15.6 [IP2015] version, Siebel VB / eScript / COM

Facing performance issue due to additional query generated When try to Open Application url with specific record row id 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Display Activity Attachment applet in separate View
2. Increase the log level to 5 for AOM
3. Directly try to open application url which point to activity attachment specific row Id

4. Observed following 2 queries to fetch record on the applet load


First Query returned all the records :-
SELECT
     T1.CONFLICT_ID,
     T1.LAST_UPD,
     T1.CREATED,
     T1.LAST_UPD_BY,
     T1.CREATED_BY,
     T1.MODIFICATION_NUM,
     T1.ROW_ID,
     T1.FILE_AUTO_UPD_FLG,
     T1.FILE_DATE,
     T1.FILE_DEFER_FLG,
     T1.FILE_DOCK_REQ_FLG,
     T1.FILE_DOCK_STAT_FLG,
     T1.FILE_EXT,
     T1.FILE_NAME,
     T1.FILE_REV_NUM,
     T1.FILE_SIZE,
     T1.FILE_SRC_PATH,
     T1.FILE_SRC_TYPE,
     T1.COMMENTS,
     CAST(? AS VARCHAR(128))
  FROM
       SIEBEL.S_ACTIVITY_ATT T1
  ORDER BY
     T1.FILE_NAME, T1.FILE_EXT

 

2nd query returned actual record for the row id provided in url

 

SELECT
     T1.CONFLICT_ID,
     T1.LAST_UPD,
     T1.CREATED,
     T1.LAST_UPD_BY,
     T1.CREATED_BY,
     T1.MODIFICATION_NUM,
     T1.ROW_ID,
     T1.FILE_AUTO_UPD_FLG,
     T1.FILE_DATE,
     T1.FILE_DEFER_FLG,
     T1.FILE_DOCK_REQ_FLG,
     T1.FILE_DOCK_STAT_FLG,
     T1.FILE_EXT,
     T1.FILE_NAME,
     T1.FILE_REV_NUM,
     T1.FILE_SIZE,
     T1.FILE_SRC_PATH,
     T1.FILE_SRC_TYPE,
     T1.COMMENTS,
     CAST(? AS VARCHAR(128))
  FROM
       SIEBEL.S_ACTIVITY_ATT T1
  WHERE
     (T1.ROW_ID = 'XXX')
  ORDER BY
     T1.FILE_NAME, T1.FILE_EXT

Cause

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
Symptoms
Cause
Solution


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