Last updated on NOVEMBER 07, 2016
Applies to:Siebel CRM - Version 188.8.131.52.14 [IP2013] and later
Information in this document applies to any platform.
On : 184.108.40.206.14 [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">
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