Item Lookup Fails With Error "ORA-01795: maximum number of expressions in a list is 1000" When Non Ranged Items Are Included In Search
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.
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