EAI Upsert Causes Repeated SQL Statement For Every Order (Doc ID 545539.1)

Last updated on DECEMBER 10, 2014

Applies to:

Siebel System Software - Version 7.5.3.5 [16183] and later
Siebel CRM - Version 7.5.3 SIA [16157] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183]
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Sun Solaris 7

This document was previously published as Siebel SR 38-1596463701.
***Checked for relevance on 06-JAN-2011***


Symptoms


The customer was performing an upsert and found that a SQL statement would be run for every order associated to an account causing a performance degradation on their integration process. The following SQL (shortened) was being generated:


SELECT t21.conflict_id, t21.last_upd, t21.created, t21.last_upd_by,

.............

FROM siebel.s_prod_int t1,

.............

siebel.s_order_item t21

WHERE t21.crse_reg_id = t2.row_id(+)

........

AND (t21.order_id = :1)

ORDER BY t21.order_id, t21.ln_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