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.
A BI Publisher reports are completing with ORA-01795 error.
User received the following in UI:
The following was observed in diagnostic logs:
[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