My Oracle Support Banner

CDI Unable To Display More that 1000 Shifts And ORA-01795 Error (Doc ID 1615168.1)

Last updated on AUGUST 04, 2022

Applies to:

Oracle Real-Time Scheduler - Version 2.1.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Information in this document applies to any platform.


After a dispatcher logs into the Contexts and Dependency Injection (CDI) window, if the user selects 30 days of data to be shown from the current date, the CDI window is unable to show the data and displays a blank window.

In the user log, it shows the following error:

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!

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