EAI UI DATA ADAPTER QUERIES FOR NULL AND DOES NOT SORT CHILD RECORDS (Doc ID 1367559.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.

Symptoms


On : 8.1.1.3 SIA[21219] version, Siebel EAI

ACTUAL BEHAVIOR
---------------
When Invoking method 'QueryPage' on business service 'EAI UI Data Adapter' and passing a sort spec at child integration component field "Created" without passing a value for the field it is considering you are also setting a searchspec [Created] IS NULL


EXPECTED BEHAVIOR
-----------------------
Looking for a way to only consider the sort.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a workflow that calls method 'QueryPage' on business service 'EAI UI Data Adapter'
2. Publish as web service
3. call with a message similar to this


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://siebel.com/asi/" xmlns:con="http://www.siebel.com/xml/360%20Contact%20Opportunity_KC">
<soapenv:Header/>
<soapenv:Body>
<asi:_sblesc360_spcContact_spcOpportunity_KC_Input>
<asi:OperationType>Query</asi:OperationType>
<asi:LoginRowID>?</asi:LoginRowID>
<con:ListOfContactOpportunity_Kc>
<!--Zero or more repetitions:-->
<con:Contact>
<!--Optional:-->
<con:Id>1-FZ6XL3</con:Id>
<!--Optional:-->
<con:ListOfOpportunity>
<!--Zero or more repetitions:-->
<con:Opportunity>
<!--Optional:-->
<!--Optional:-->
<con:Created sortorder="DESC" sortsequence="1"></con:Created>
</con:Opportunity>
</con:ListOfOpportunity>
</con:Contact>
</con:ListOfContactOpportunity_Kc>
<asi:Role>?</asi:Role>
<asi:SourceSystem>?</asi:SourceSystem>
<asi:LOB>?</asi:LOB>
</asi:_sblesc360_spcContact_spcOpportunity_KC_Input>
</soapenv:Body>
</soapenv:Envelope>



4. Notice in logs a searchspec looking for created = null is generated which would not make sense for the system generated field Created.
Also notice the sortspec gets created too and that part is ok.

Begin: SetSearchSpec for SqlObj 'Opportunity' at 13fcdf10, Search Spec: '[Created] IS NULL AND (([Hospitality Template Flag] = 'N'))'



and that goes to the where clause

WHERE
(T1.CREATED IS NULL AND T1.TEMPLATE_FLG = 'N') AND
(T2.PER_ID = ?)
ORDER BY
T1.CREATED DESC




BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add solely a sortspec at a child field

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