Error "ORA-00001: unique constraint (ERPI.AIF_EBS_GL_CCID_STG_U1) violated" When Running ERPi Data Load Rule (Doc ID 1907514.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.2.300 and later
Information in this document applies to any platform.

Symptoms

When data load is run from EBS to Planning using ERPi loaddata.sh, one of the data loads (usually the first data load) fails with the following error message:

ODI-1217: Session EBS_GL_LOAD_BALANCES_DATA (2033501) fails with return code 1.
ODI-1226: Step EBS Extract Code Combinations fails after 1 attempt(s).
ODI-1240: Flow EBS Extract Code Combinations fails while performing a Loading operation. This flow loads target table AIF_EBS_GL_CCID_STG.
ODI-1228: Task SS_0 (Loading) fails on the target GENERIC_SQL connection ERPI_DATA_SERVER.
Caused By: java.sql.BatchUpdateException: ORA-00001: unique constraint (ERPI.AIF_EBS_GL_CCID_STG_U1) violated
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)

The data load works fine if it is done through ERPi console from Workspace as it loads the data in serial mode. The data load fails if it is run in batches through loaddata.sh script. If the failed data load is run again manually then it completes successfully.

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