Item Lookup Fails With Error "ORA-01795: maximum number of expressions in a list is 1000" When Non Ranged Items Are Included In Search

(Doc ID 2015301.1)

Last updated on APRIL 08, 2018

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.2 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

When attempting to perform a Item Lookup including non ranged items  the following error occurs.

Steps to replicate:
1. Identify an item hierarchy where in less than 500 items ranged and more than 1000 items non-ranged.
2. Now go to Item Lookup screen in SIM UI and provide the hierarchy details and check Non-ranged option button and keep the default search limit as 500.


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