FEM_BALANCES Spreadsheet Load Fails with Error Duplicate Rows Entered

(Doc ID 966354.1)

Last updated on NOVEMBER 23, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to - Release: 11.5 to 11.5
Information in this document applies to any platform.


In Enterprise Performance Foundation Administrator, you are trying to upload data to FEM_BALANCES using the WebADI "Spreadsheet Load" option.  When you try to upload the rows from the spreadsheet, the following error appears in the Messages column:

Duplicate rows entered.

The rows in the spreadsheet do not violate the unique index on FEM_BALANCES.  The rows do contain some unique dimension member values.

Steps to reproduce:
  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Process Management > Spreadsheet Load
  3. Select "Upload Item" = Table and Table Name = Balances
  4. Click on Launch Spreadsheet
  5. Populate the Spreadsheet with appropriate data
  6. Select Oracle > Upload
The error occurs in the Messages column of the spreadsheet.


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