Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 18.104.22.168  and later
Information in this document applies to any platform.
""Checked For Relevance on 12-May-2015""
On : 22.214.171.124 SIA  version, Configuration - General
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:
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
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?
There should not be any Strange join SIEBEL.(SLA 5) S_POSTN.OU_ID = T3.PAR_ROW_ID when querying in Account
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms