TBUI SQL Generated Without Proper WHERE Clause (Doc ID 1943949.1)

Last updated on JULY 26, 2017

Applies to:

Siebel Financial Services CRM - Version 8.1.1.11 [IP2013] to 8.1.1.11.16 [IP2013] [Release V8]
Siebel Financial Services CRM - Version 16.0 [IP2016] and later
Information in this document applies to any platform.
**checked for relevance on 26-JUL-2016***

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

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