LOV Issue With Siebel Upgrade From 8.0 To 8.1 (Doc ID 1490958.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.7 SIA [21238] and later
Information in this document applies to any platform.
""Checked for relevance on 28-Feb-2014""

Symptoms

On :  8.1.1.7 SIA [21238] version, Configuration - General

ACTUAL BEHAVIOR  
---------------
After upgraded to 8.1.1.7, the sql has additional criteria in the WHERE clause for the Activity type LOV

In 8.0 sql is generated as below which works fine


  SELECT
      T2.CONFLICT_ID,
     T2.LAST_UPD,
      T2.CREATED,
      T2.LAST_UPD_BY,
      T2.CREATED_BY,
      T2.MODIFICATION_NUM,
      T2.ROW_ID,
      T1.VAL,
      T2.ORDER_BY,
      T2.VAL,
      T2.TYPE,
      T2.BU_ID
   FROM
       SBBP01.S_LST_OF_VAL T1,
       SBBP01.S_LST_OF_VAL T2
   WHERE
      T2.PAR_ROW_ID = T1.ROW_ID AND
      ((T2.LANG_ID = :1) AND
      (T2.ACTIVE_FLG = :2 OR T2.ACTIVE_FLG IS NULL) AND
      (T1.VAL IS NOT NULL) AND
      (T2.TYPE = :3 AND T2.BU_ID IS NULL AND T1.VAL = :4)) AND
     (T1.VAL = :5 AND T2.TYPE = :6)
   ORDER BY
      T2.ORDER_BY

Bind variable 1: ENU
Bind variable 2: Y
Bind variable 3: TODO_TYPE
Bind variable 4: NAV AM Activity
Bind variable 5: NAV AM Activity
Bind variable 6: TODO_TYPE

=====================================================

In 8.1.1.7 sql is generated as below which DOES NOT WoRK, as you can see it is adding some criteria

T1.VAL = 'NAV AM Activity' AND T1.VAL = 'General')) T1.VAL = 'General'


SELECT
      T2.CONFLICT_ID,
      T2.LAST_UPD,
      T2.CREATED,
      T2.LAST_UPD_BY,
      T2.CREATED_BY,
      T2.MODIFICATION_NUM,
      T2.ROW_ID,
      T2.ORDER_BY,
      T1.VAL,
      T2.TYPE,
      T2.VAL,
      T2.BU_ID
   FROM
       SBBP01.S_LST_OF_VAL T1,
       SBBP01.S_LST_OF_VAL T2
   WHERE
      T2.PAR_ROW_ID = T1.ROW_ID AND
      ((T2.LANG_ID = 'ENU') AND
      (T2.ACTIVE_FLG = 'Y' OR T2.ACTIVE_FLG IS NULL) AND
      (T1.VAL IS NOT NULL) AND
      (T2.TYPE = 'TODO_TYPE' AND T2.BU_ID IS NULL AND T1.VAL = 'NAV AM Activity' AND T1.VAL = 'General')) AND
      (T1.VAL = 'NAV AM Activity' AND T2.TYPE = 'TODO_TYPE')
   ORDER BY
      T2.ORDER_BY

SELECT
      T2.CONFLICT_ID,
      T2.LAST_UPD,
      T2.CREATED,
      T2.LAST_UPD_BY,
      T2.CREATED_BY,
      T2.MODIFICATION_NUM,
      T2.ROW_ID,
      T2.ORDER_BY,
      T1.VAL,
      T2.TYPE,
      T2.VAL,
      T2.BU_ID
   FROM
       SBBP01.S_LST_OF_VAL T1,
       SBBP01.S_LST_OF_VAL T2
   WHERE
      T2.PAR_ROW_ID = T1.ROW_ID AND
      ((T2.LANG_ID = 'ENU') AND
      (T2.ACTIVE_FLG = 'Y' OR T2.ACTIVE_FLG IS NULL) AND
      (T1.VAL IS NOT NULL) AND
      (T2.TYPE = 'TODO_TYPE' AND T2.BU_ID IS NULL AND T1.VAL = 'NAV AM Activity' AND T1.VAL = 'General')) AND
      (T1.VAL = 'NAV AM Activity' AND T2.TYPE = 'TODO_TYPE')
   ORDER BY
      T2.ORDER_BY

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