My Oracle Support Banner

FDMEE Data Load Mapping fails by Error Cannot insert duplicate key row in object 'dbo.TDATAMAP' with unique index 'PK_TDATAMAP_UI' (Doc ID 2619745.1)

Last updated on OCTOBER 08, 2021

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

Symptoms

Customer trying to import the Data Load Mapping(Data Management -> WorkFlow->Data Load Mapping) using Excel OR try to import Data Load Mapping using LCM process get fails at Import Process.

In UI can see below error

EPMLCM-14000: Error reported from FDM Enterprise Edition.
/Application Data/Consolidation Applications/<Application Name>/Data Load Mapping:- EPMFDM-140072:Import for Data Load Mapping failed.

+++AIF_WebAPP.log having following errors+++

[2019-12-09T14:16:46.867-05:00] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.ui] [tid: 12] [userId: <anonymous>] [ecid: 00ixy1PTRd2Fw00Fzzw0w00001Rc000NGm,0:1:1] [APP: AIF#11.1.2.0] [SRC_CLASS: sun.reflect.NativeMethodAccessorImpl] [SRC_METHOD: invoke0] EPMFDM-140098:Unexpected error occurred.[[
java.lang.RuntimeException: EPMFDM-140098:Unexpected error occurred.

Caused by: java.lang.RuntimeException: EPMFDM-140274:Message - {0}

Caused by: java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'dbo.TDATAMAP' with unique index 'PK_TDATAMAP_UI'.

 

Cause

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
Symptoms
Cause
Solution


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