Detail Client Data Loader Fails with FEM_SD_LDR_DUPLICATE_ROW Error in Interface Table

(Doc ID 437776.1)

Last updated on NOVEMBER 18, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.

Symptoms

In Enterprise Performance Foundation Administrator, the "Detail Client Data Loader" program ends with an error, fails to load any records, and contains the following in the View Log:

The request was run with the following parameters:

CALP_DIM_GRP_DISPLAY_CODE: OGL_1
CAL_PERIOD_NUMBER: 1
CAL_PERIOD_END_DATE: 31-JAN-05
LEDGER_DISPLAY_CODE: Vision Operations (USA)
DATASET_DISPLAY_CODE: ACTUALS
SOURCE_SYSTEM_DISPLAY_CODE: FEM
TABLE_NAME : FEM_DATA10

The execution mode is 'S'.

0 rows loaded successfully.
123 rows failed to load successfully.

The execution produced errors. Correct the errors and rerun.

The interface FEM_xxxxxxx_T table contains the following error in the STATUS column:

FEM_SD_LDR_DUPLICATE_ROW

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