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 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.

Symptoms

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.

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