Error "ORA-00001: unique constraint (ERPI.AIF_EBS_GL_CCID_STG_U1) violated" When Running ERPi Data Load Rule
Last updated on AUGUST 01, 2016
Applies to:Hyperion Financial Data Quality Management - Version 126.96.36.199.300 and later
Information in this document applies to any platform.
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
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.
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