My Oracle Support Banner

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 MAY 30, 2018

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


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.