My Oracle Support Banner

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 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-2XXXJ'">
<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..

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.