My Oracle Support Banner

Query for Household Number on existing record does not work (Doc ID 536765.1)

Last updated on JANUARY 29, 2020

Applies to:

Siebel eAuction - Version 7.0.4.215 [14172] and later
Siebel CRM - Version 7.0.4.215 [14172] and later
Siebel eAdvisor - Version 7.0.4.215 [14172] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.0.4.215 [14172] FRA

Database: Oracle 8.1.7.4

Application Server OS: Microsoft Windows 2000 Advanced Server SP 2

Database Server OS: Microsoft Windows 2000 Advanced Server SP 2



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

Symptoms

Here's an odd behaviour on Households' queries I could reproduce on the sample database and standard SRF as follows:

1- In the My Households list, select an household (like 1-EKBT or 1-COQ0) and copy its number
2- Click on Query
3- Paste the copied number in the column Household number
4-Click on execute

The household, which was visible in the My Households view, does not appear. It appears when I select the All Households view. I double-checked that I belong to the sales team of that Household, and the visibility settings are OK, but the SQL generated is not correct:

SELECT
      T2.LAST_UPD_BY,
      T2.ROW_ID,
...
      T10.NAME,
      T7.DFLT_ORDER_PROC_CD
   FROM
       SIEBEL.S_PARTY T1,
       SIEBEL.S_PARTY T2,
       SIEBEL.S_PARTY T3,
       SIEBEL.S_CONTACT T4,
       SIEBEL.S_ORGGRP_POSTN T5,
       SIEBEL.S_USER T6,
       SIEBEL.S_CONTACT T7,
       SIEBEL.S_POSTN T8,
       SIEBEL.S_ADDR_PER T9,
       SIEBEL.S_ORG_GROUP T10
   WHERE
      T10.PR_CON_ID = T7.PAR_ROW_ID (+) AND
      T7.PR_PER_ADDR_ID = T9.ROW_ID (+) AND
      T2.ROW_ID = T10.PAR_ROW_ID AND
      T10.PR_CON_ID = T3.ROW_ID (+) AND
      T10.PR_CON_ID = T4.PAR_ROW_ID (+) AND
      T5.POSTN_ID = :1 AND T10.ROW_ID = T5.ORGGRP_ID AND
      T1.ROW_ID = T5.POSTN_ID AND
      T5.POSTN_ID = T8.PAR_ROW_ID (+) AND
      T8.PR_EMP_ID = T6.PAR_ROW_ID (+) AND
      (T5.GROUP_TYPE_CD != 'Book of Clients' AND T5.GROUP_TYPE_CD IS NOT NULL) AND
      (T5.GRP_NAME = :2)
   ORDER BY
      T7.LAST_NAME, T7.FST_NAME

Bind variable 1: 0-5220
Bind variable 2: 1-ZPQ5

As you can see, for performance reasons Siebel queries S_ORGGRP_POSTN.GRP_NAME instead of S_ORG_GROUP.NAME but values differ.

Changes

 

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
Changes
Cause
Solution
 Message 1

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