My Oracle Support Banner

Strange Join SIEBEL.(SLA 5) S_POSTN.OU_ID = T3.PAR_ROW_ID Into A Query In Account (Doc ID 1601890.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.
""Checked For Relevance on 12-May-2015""

Symptoms

On : 8.1.1.7 SIA [21238] version, Configuration - General

ACTUAL BEHAVIOR
---------------
 I have a problem with a query that Siebel it's doing when I do a records count in Account, where I did a search by the field CUST_STAT_CD .I did the same thing with vanilla and everyting worked OK but without vanilla it makes a strange query and I don't know from it comes.Next you'll have the queries:

With Vanilla:

SELECT
  COUNT (*)
  FROM
  SIEBEL.S_ACCNT_POSTN T1,
  SIEBEL.S_PARTY T2,
  SIEBEL.S_PARTY T3,
  SIEBEL.S_ORG_EXT T4
  WHERE
  T3.ROW_ID = T4.PAR_ROW_ID AND
  T4.PR_POSTN_ID = T1.POSITION_ID AND T4.ROW_ID = T1.OU_EXT_ID AND
  T1.POSITION_ID = T2.ROW_ID AND
  (T4.INT_ORG_FLG != 'Y' OR T4.PRTNR_FLG = 'Y') AND
  (T4.CUST_STAT_CD LIKE 'ESTC001*')


Time: 3.276 seconds Records: 143331


Without Vanilla:

SELECT
  COUNT (*)
  FROM
  SIEBEL.S_ORG_EXT T1,
  SIEBEL.S_PARTY T2,
  SIEBEL.S_ORG_EXT T3,
  SIEBEL.S_ORG_EXT T4
  WHERE
  T4.MASTER_OU_ID = T1.PAR_ROW_ID AND
  T2.ROW_ID = T4.PAR_ROW_ID AND
  SIEBEL.(SLA 5) S_POSTN.OU_ID = T3.PAR_ROW_ID (+) AND
  ((T4.ACTIVE_FLG = 'N') AND
  ((T4.INT_ORG_FLG != 'Y' OR T4.PRTNR_FLG != 'N') AND T4.ACCNT_FLG != 'N')) AND
  (T4.CUST_STAT_CD IN ( ' ESTC001' ))


Time:it's not ending Records:143331

  As you can see it makes a strange join in the query without vanilla SIEBEL.(SLA 5) S_POSTN.OU_ID = T3.PAR_ROW_ID .
  Can you please help me to find from where it comes this join and how to quit this strange expresion?



EXPECTED BEHAVIOR
-----------------------
There should not be any Strange join SIEBEL.(SLA 5) S_POSTN.OU_ID = T3.PAR_ROW_ID when querying in Account

STEPS
-----------------------
customer specific

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.