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.
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"
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