My Oracle Support Banner

Initialization Of EBS Source System Fails In FDMEE "ODI-1228: Task EBS Extract COA Ledgers (Integration) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER." (Doc ID 2520952.1)

Last updated on JANUARY 16, 2020

Applies to:

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

Symptoms

When attempting to initialize the EBS source system after one of the ledgers changed its chart of accounts, it fails.

The following error is seen in the process log -
2019-03-19 08:15:00,553 FATAL [AIF]: Error in Launch EBS Setup Source System

The odiagent.log has the following 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 (<database>.AIF_COA_LEDGERS_U1) violated

 

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
References


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