My Oracle Support Banner

MVG Primary Joins (Doc ID 479443.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Siebel Tools - Version SIA [16199] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: [16199] Fin Svcs
Database: IBM DB2 for zOS and OS/390 v8
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: IBM OS/390

This document was previously published as Siebel SR 38-3207915031.


On our Service Request buscomp we have defined a multi-value link to S_SRV_REQ_XM. The MVL is defined with a primary.

When we bring up an SR list and spool the sql we see the outer join to S_SRV_REQ_XM using the primary from Service Request but then we see a bunch of subqueries for each row in the list as it tries to find a row from S_SRV_REQ_XM to use in the GUI.

The funny thing is that the primary field on each SR is properly valued so there should be no need for the subqueries. This is obviously a performance issue and we would like to figure it out. Any ideas?




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.