SWIProductImport failing when trying to add a child product using Workspace Project with over 1000 objects (Doc ID 2247031.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

On : 15.12 [IP2015] version, Order Management

SWIProductImportUpsert (SWIProductImport) not working when adding new child product to a parent customizable product.

When we add a new child item to a CPC in PIM (Product Item Master) and publish to Siebel it's failing. The call works if we update an existing child item or delete a child item from the CPC. We are migrating to 8.1.1.15 from 8.1.1.5. This works in 8.1.1.5 but fails in 8.1.1.15.

In the log we are seeing a Named Search 'VOD Component Search' for ISS Class Products causing the issue with MANY rowids.
 

ERROR
-----------------------
In SOAP Response:
Method 'SetFieldValue' of business component 'SWI ISS Product Structure Admin BusComp' (integration component 'SWI ISS Product Structure Admin BusComp') for record with search specification '[Item Name] = "Intuit QuickBooks Accountant" AND [Last Version] IS NULL' returned the following error:"An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)"(SBL-EAI-04451)

In the log file, it is seen as:
SQLParseAndExecute Execute 5 0000008058d21070:0 2017-03-22 16:13:41 ORA-01795: maximum number of expressions in a list is 1000


STEPS
-----------------------
1. Create a new Workspace Projects.
2. Add over 1000 products to the workspace.
3. Execute the web service SWIProductImportUpsert to add a child product to a
parent CP, using workspace projects created above.
4. Error will be seen.
5. Change the payload to point to a empty workspace projects and run the web service again. This time there is no error.

BUSINESS IMPACT
-----------------------
Due to this, unable to keep product in sync between external system and Siebel.

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