TBUI SQL Generated Without Proper WHERE Clause

(Doc ID 1943949.1)

Last updated on MAY 10, 2018

Applies to:

Siebel Financial Services CRM - Version 16.0 [IP2016] to 16.14 [IP2016] [Release V16]
Siebel Financial Services CRM - Version 8.1.1.7 SIA [21238] and later
Information in this document applies to any platform.


** checked for relevance on 26-JUL-2016 ***

** checked for relevance on 10-MAY-2018 ***

Symptoms

On : 8.1.1.7 SIA [21238] version, Task Based UI

TBUI SQL statements are causing performance issues: a JOIN should exist between the tables that are listed in the 'FROM' SQL clause

There is no join between the S_TU_LOG* tables that are listed in the 'FROM' SQL clause.

 

Example of SQL being generated:

-----------------------------------------

SELECT
     T2.ROW_ID,
     T2.FLD_NAME_V15_13,
     T2.FLD_NAME_DN_05,
     T2.TBL_NAME,
     T2.FLD_VAL_V30_04,
     T2.TASK_ID_VAL,
     T2.FLD_VAL_V15_22,
     T2.FLD_VAL_V15_19,
     T2.FLD_VAL_V30_02,
     T2.FLD_VAL_C1_03,
     T2.FLD_VAL_V15_14,
     T2.FLD_VAL_V15_13,
     T2.REC_MOD_NUM,
     T2.FLD_VAL_V15_08,
     T2.FLD_VAL_V15_29,
     T2.FLD_VAL_V50_03,
     T2.FLD_VAL_DN_04,
     T2.FLD_NAME_V15_29,
     T2.BC_NAME,
     T2.OPERATION,
     T2.FLD_NAME_V15_14,
     T2.SAVE_POINT_NUM,
     T2.FLD_NAME_V15_08,
     T2.FLD_NAME_DN_01,
     T2.LINK_NAME,
     T2.FLD_NAME_DN_04,
     T2.FLD_NAME_V30_02,
     T2.PARENT_ID_VAL,
     T2.FLD_NAME_V50_03,
     T2.FLD_VAL_DN_02,
     T2.FLD_VAL_DN_05,
     T2.TASK_ROW_ID_VAL,
     T2.TASK_BC_ID_VAL,
     T2.FLD_NAME_V15_19,
     T2.FLD_NAME_V30_04,
     T2.FLD_NAME_V15_22,
     T2.FLD_NAME_DN_03,
     T2.FLD_NAME_DN_02,
     T2.FLD_VAL_DN_01,
     T2.FLD_VAL_DN_03,
     T2.BASE_TBL_NAME,
     T2.FLD_NAME_C1_03
  FROM
      SIEBEL.S_TU_LOG_X_01 T1,
      SIEBEL.S_TU_LOG T2
  WHERE
     (T2.TASK_ID_VAL = :1 AND T2.SAVE_POINT_NUM >= :2)
  ORDER BY
     T2.TASK_ID_VAL, T2.SAVE_POINT_NUM

Changes

 

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