ExecutionMode (ForwardOnly) Is Not Applied For Child Integration Components in OrderDetailWebService (Doc ID 2201623.1)

Last updated on NOVEMBER 07, 2016

Applies to:

Siebel CRM - Version 8.1.1.11.14 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On :  8.1.1.11.14 [IP2013] version, Siebel EAI

ACTUAL BEHAVIOR  
---------------
ExecutionMode (ForwardOnly) is not applied for child Integration Components using OrderDetailWebService


Interface to retrieve list of Orders along with Order Items is not working as it's failing of there are more than 10000 orderl line items.
It was repliacted on vanilla OrderDetailWebService.

Below request which was used for tests (ExecutionMode set to ForwardOnly as per http://docs.oracle.com/cd/E14004_01/books/EAI2/EAI2_UseEAIAdapt13.html#wp430879):

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:det="http://siebel.com/OrderManagement/Order/Details" xmlns:quer="http://siebel.com/OrderManagement/Order/Details/Data/Query">
<soapenv:Header/>
<soapenv:Body>
<det:OrderDetailQueryPage_Input>
<quer:ListOfOrderDetail pagesize="100" startrownum="0" recordcountneeded="false">
<quer:OrderDetail searchspec="[BillingProfileId]='1-2ZVQJ'">
<quer:Id></quer:Id>
<quer:ListOfOrderItemDetail>
<quer:OrderItemDetail>
<quer:Id></quer:Id>
</quer:OrderItemDetail>
</quer:ListOfOrderItemDetail>
</quer:OrderDetail>
</quer:ListOfOrderDetail>
<det:ExecutionMode>ForwardOnly</det:ExecutionMode>
<det:LOVLanguageMode>LIC</det:LOVLanguageMode>
<det:ViewMode>All</det:ViewMode>
</det:OrderDetailQueryPage_Input>
</soapenv:Body>
</soapenv:Envelope>


Error received in response:
Method 'Home' of business component 'PDS Simplified Order Entry - Line Items' (integration component 'PDS Simplified Order Entry - Line Items') returned the following error:
"There were more rows than could be returned.  Please refine your query to bring back fewer rows(SBL-DAT-00500)"(SBL-EAI-04376)
 

EXPECTED BEHAVIOR
-----------------------
Since ExecutionMode=ForwardOnly, error message should not occur.

STEPS
-----------------------
To reproduce, use the webservice ORDERDETAILWEBSERVICE to query for line items of a order that has more than 10000 line items. To create many line items, the Auto-Explode can be used.

BUSINESS IMPACT
-----------------------
Unable to query orders with more than 10000 line items..

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