My Oracle Support Banner

FDMEE source Initialization fails with error "SQLIntegrityConstraintViolationException: ORA-00001: unique constraint XXXXX violated" (Doc ID 2351391.1)

Last updated on OCTOBER 26, 2021

Applies to:

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

Symptoms

When attempting to initialize the EBS source,
the following error occurs.

Issue observed only when EBS was migrated.

ERROR
-----------------------
 -ODI-1228: Task EBS Extract COA Ledgers (Integration) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER.
 -Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (HYP_FDM.AIF_COA_LEDGERS_U2) violated


Changes

 EBS was migrated from version 11 to 12.2 

 

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
Changes
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.