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 11.1.2.3.000 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.000 version, BPM Architect

When attempting to ,
the following error occurs.

ERROR
-----------------------

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


STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
Unable to clear data

Cause

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