IBM Support

ORA-01795: maximum number of expressions in a list is 1000 *|* -C25B5666AA2EF00E85257917007A9125- *|*

Question & Answer


Question

ORA-01795: maximum number of expressions in a list is 1000 *|* -C25B5666AA2EF00E85257917007A9125- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

ORA-01795: maximum number of expressions in a list is 1000

Symptom

There is a limitation with Oracle where it does not accept more than 1000 items in an IN statement. This limitation may cause an issue under the following circumstances.

1. In Multi Channel Selling (MCS) version 7.0.1 only:

  • Updating partner status when hierarchy has more than 1000 partners
  • PartnerAssignment API's which take an ArrayList of partnerKeys

2. A model with more than 1000 properties when the "Properties" tab of this model is clicked

Error Message

ORA-01795: maximum number of expressions in a list is 1000


Resolving the problem

This has been fixed in HF11980 in MCS v7.0.1 and has been reconciled in later versions.

Cross reference information
SegmentProductComponentPlatformVersionEdition
CommerceSterling Selling and Fulfillment SuiteMCS - Platform

Historical Number

NFX2850

Product Alias/Synonym

Severity


Normal

Type


NormalFix

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10769275

Page Feedback