My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel System Software - Version [16183] and later
Siebel CRM - Version 7.5.3 SIA [16157] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: [16183]
Database: Oracle
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***


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.