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 7.5.3.5 [16183] and laterSiebel 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
.............
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
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
Symptoms |
Cause |
Solution |