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: 11.5.10.2 and later   [Release: 11.5 and later ]
Oracle Enterprise Performance Foundation - Version: 11.5.10.2 and later    [Release: 11.5 and later]
Information in this document applies to any platform.

Symptoms

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:

Error

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
  • FEM_QUERY_FAILED
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.

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