My Oracle Support Banner

BI Publisher Reports Are Completing ORA-01795 Error (Doc ID 2503599.1)

Last updated on AUGUST 01, 2022

Applies to:

Oracle Fusion Purchasing Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.


A BI Publisher reports are completing with ORA-01795 error.

User received the following in UI: oracle.xdo.XDOException: java.lang.IndexOutOfBoundsException: Invalid index: 0

The following was observed in diagnostic logs:

[2019-02-04T22:41:45.601+00:00][dp id:493361764][sch info:JobId:3858[ESS RequestId:97837]]XMLPGEN:ORA-01795: maximum number of expressions in a list is 1000

[2019-02-04T22:41:45.602+00:00][dp id:493361764][sch info:JobId:3858[ESS RequestId:97837]]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

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