List Management - Performance Issue (Doc ID 2269488.1)

Last updated on AUGUST 20, 2017

Applies to:

Siebel Marketing - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

Where clause not getting generated for while adding a prospect to the list.

Steps to reproduce:-

Navigate to List Management > Prospects
Select a Prospect and click 'Add To List'
Select a List and click 'Ok'

 

The following sql is generated which has only outer joins in the where clause which makes the query expensive

SELECT /*+ ALL_ROWS */
T3.CONFLICT_ID,
T3.LAST_UPD,
T3.CREATED,
T3.LAST_UPD_BY,
T3.CREATED_BY,
T3.MODIFICATION_NUM,
T3.ROW_ID,
T1.EMAIL_ADDR,
T3.CON_PER_ID,
T2.EMAIL_ADDR,
T3.PRSP_CON_PER_ID,
:1
FROM
SIEBEL.S_CONTACT T1,
SIEBEL.S_PRSP_CONTACT T2,
SIEBEL.S_CALL_LST_CON T3
WHERE
T3.CON_PER_ID = T1.PAR_ROW_ID (+) AND
T3.PRSP_CON_PER_ID = T2.ROW_ID (+)
ORDER BY
T1.LAST_NAME, T2.LAST_NAME

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