Unable To Refresh Data Reporting Application: Error 1013358 (Doc ID 2119938.1)

Last updated on MARCH 23, 2016

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 16.03.53 and later
Information in this document applies to any platform.

Symptoms

Push Data Failed. Error: the Hyperion Essbase operation failed with an error code: 1013358

When building a reporting application (ASO) they get an error 1013358

Member names here are just an example

there is a part of a clear script
Clear data script: CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(CrossJoin(Descendants([SAD],[SAD].Levels(0)),Descendants([Type_Value],[Type_Value].Levels(0))), ... etc

The [APPNAME_ODL.log] was set to [NOTIFICATION:16]
it does not tell us which dimension or member was incorrect all it reports is
[2016-03-22T09:43:45.70+00:00] [APPNAME] [NOTIFICATION:16] [REQ-358] [REQ] [ecid: 1458634105796,0] [tid: 139736306731328] [DBNAME: Database] Dynamic members are not allowed in data clear region specification

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