"<Dimension Name>" is an Invalid Value for "Child Member";"<Dimension Name>" is an Invalid Value for "Parent Member"
Last updated on OCTOBER 05, 2012
Applies to:Oracle Profitability Manager - Version 184.108.40.206 and later
Oracle Enterprise Performance Foundation - Version 220.127.116.11 and later
Information in this document applies to any platform.
Checked for relevance on 05-Oct-2012.
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:
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:
- Go to the Profitability Manager responsibility
- Go to Business Rule > Dimension > Hierarchy
- Click on "Create from Spreadsheet"
- Populate the spreadsheet with hierarchy data
- Select Add-Ins > Oracle > Upload
The error appears.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms