"<Dimension Name>" is an Invalid Value for "Child Member";"<Dimension Name>" is an Invalid Value for "Parent Member" (Doc ID 1286447.1)

Last updated on OCTOBER 05, 2012

Applies to:

Oracle Profitability Manager - Version 11.5.10.2 and later
Oracle Enterprise Performance Foundation - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 05-Oct-2012.

Symptoms

In Oracle Profitability Manager (PFT) 11i, you are trying to upload a hierarchy using the "Create from Spreadsheet" option.  You are using a Level Use Code of "Sequence Enforced" or "Sequence Enforced - Skip Level".  After you enter the hierarchy data in the WebADI spreadsheet and select Oracle > Upload, the following error appears in the Upload Parameters screen:

Error

The upload process has completed with errors. Press Close to return to the document and fix the errors.

* No rows uploaded
* xxx rows were invalid

The following error is in the Messages column of the spreadsheet:

"<Dimension Name>" is an invalid value for "Child Member";"<Dimension Name>" is an Invalid value for "Parent Member"

The error prevents you from loading the hierarchy.

Steps to Reproduce:

  1. Go to the Profitability Manager responsibility
  2. Go to Business Rule > Dimension > Hierarchy
  3. Click on "Create from Spreadsheet"
  4. Populate the spreadsheet with hierarchy data
  5. Select Add-Ins > Oracle > Upload

The error appears.

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