ExecutionMode (ForwardOnly) Is Not Applied For Child Integration Components in OrderDetailWebService
(Doc ID 2201623.1)
Last updated on FEBRUARY 01, 2019
Applies to:Siebel CRM - Version 184.108.40.206.14 [IP2013] and later
Information in this document applies to any platform.
On : 220.127.116.11.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..
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document