EAI Siebel Adapter Performance Problem During Order Upsert (Web Service SWIOrderUpsert) (Doc ID 1581700.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Communications, Media and Energy CRM - Version 8.1.1.6 SIA [21233] and later
Information in this document applies to any platform.

Symptoms

During execution of the SWIOrderUpsert web service request, using Integration Object SWIOrderIO, it was observed that after every Line Item update, SQL was being generated, similar to :-

 Where the incoming Order had multiple Line Items, the above SQL was responsible for the majority of the time taken to process the request.

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