Unable to Clear Account Annotations Supporting from Planning using Clear Cell details Error: "java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000"

(Doc ID 1956800.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Hyperion Planning - Version and later
Information in this document applies to any platform.


On : version, BPM Architect

When attempting to ,
the following error occurs.


java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

The issue can be reproduced at will with the following steps:
To clear cell details:
1 Select Administration, then Manage, the Clear Cell Details.
2 For Plan Type, select a plan type, and click Go.
When you click Go, dimensions are selectable for the plan type.
3 Select members for the data intersections:
4. Click on clear , See the error

Unable to clear data


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 hundreds of Community platforms