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:

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

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