My Oracle Support Banner

SIM Product Group Scheduler Fails With 'java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000' (Doc ID 1467803.1)

Last updated on SEPTEMBER 22, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 13.2 to 16.0.3 [Release 13.2 to 16.0]
Information in this document applies to any platform.

Symptoms


In Store Inventory Management (SIM), if a user is authorized to access all stores in SIM (more than 1000 stores), when selecting "All Stores" when filtering the list of available product group schedules, SIM fails with the following error:

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

 
Steps to Reproduce:

1. Ensure that the test environment has more than 1000 stores.
2. Ensure that a user is authorized in SIM to have access to all stores.
3. Go into the "Product Group Schedule" screen, click on "Filter", and select All Stores.

Observe the following error as it builds up a query with an "in" statement, and that "in" statement has all stores that user has access to:
"Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000"

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.