My Oracle Support Banner

FEM_QUERY_FAILED Error Uploading Hierarchy Data from WebADI Spreadsheet (Doc ID 1286367.1)

Last updated on FEBRUARY 13, 2011

Applies to:

Oracle Profitability Manager - Version: and later   [Release: 11.5 and later ]
Oracle Enterprise Performance Foundation - Version: and later    [Release: 11.5 and later]
Information in this document applies to any platform.


In Oracle Profitability Manager (PFT) 11i, you are trying to upload a hierarchy using the "Create from Spreadsheet" option.  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.
  • Upload validation aborted
  • No rows uploaded
  • 3 rows were invalid
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 in the window that opens.


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

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