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

(Doc ID 2201623.1)

Last updated on OCTOBER 10, 2017

Applies to:

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


On : [IP2013] version, Siebel EAI

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">
<quer:ListOfOrderDetail pagesize="100" startrownum="0" recordcountneeded="false">
<quer:OrderDetail searchspec="[BillingProfileId]='1-2ZVQJ'">

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)

Since ExecutionMode=ForwardOnly, error message should not occur.

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.

Unable to query orders with more than 10000 line items..


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