My Oracle Support Banner

Error: 'Essbase Error(1012004): Invalid member name [null] ' While Exporting the Data to PBCS Application (Doc ID 2689067.1)

Last updated on AUGUST 07, 2024

Applies to:

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

Symptoms

Export to PBCS Application in REPLACE mode fails with error:

Error

=====

INFO  [AIF]: cloudServiceType: Planning, Resolved user: epm_default_cloud_admin, planningUserName: XXXXXX
INFO  [AIF]: Starting executeDataRuleFile...
INFO  [AIF]: Building and executing replace data script...
INFO  [AIF]: Replace data script: 
FIX (<fixMbrs>,"Dec","FY19")
CLEARDATA "null";
ENDFIX
ERROR [AIF]: Cannot calculate. Essbase Error(1012004): Invalid member name [null]
INFO  [AIF]: EssbaseService.loadData - END (false)
FATAL [AIF]: Error in CommData.loadData
Traceback (most recent call last):
  File "<string>", line 4011, in loadData
RuntimeError: false

Changes

Issue started happening after the 20.06 update, verifying the log file shows that it is executing a fix statement with clear data script.  20.06 onwards replace will work for all data types, it adds the fix statement with CLEARDATA.
It is based on the export mode chosen during the rule execution.

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.