My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2020

Applies to:

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

Symptoms

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

User received the following in UI:

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: 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

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


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