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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms