EAI Upsert Causes Repeated SQL Statement For Every Order
(Doc ID 545539.1)
Last updated on MARCH 01, 2018
Applies to:Siebel System Software - Version 184.108.40.206  and later
Siebel CRM - Version 7.5.3 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
Database: Oracle 18.104.22.168
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:
FROM siebel.s_prod_int t1,
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!