My Oracle Support Banner

Import Activity Unsuccessful (Doc ID 2233443.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : NA version, Accounts, Contacts, Households

Import Activity unsuccessful

We use a specific auxiliary dimension (Zone) to assign the accounts to sales persons (fix the portfolios).

Having followed a lot of times the specific import activity and mapping file, no issue appeared before.

Trying to implement the procedure for a new update, the status becomes unsuccessful.

I cannot understand the error in order to correct it.


Unexpected ODI Fault
ODI-1226: Step OdiWaitForChildSession 40 fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails. Caused By: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30005: One or more child sessions has failed at at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute( at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction( at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand( at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute( at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute( at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask( at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(

58204502 - CLASSIFICATION_LOAD: ODI-1217: Session CLASSIFICATION_LOAD (58204502) fails with return code 1. ODI-1226: Step CLASSIFICATION_UPDATE_CODE_ASSIGNMT fails after 1 attempt(s). ODI-1240: Flow CLASSIFICATION_UPDATE_CODE_ASSIGNMT fails while performing a Integration operation. This flow loads target table HZ_CODE_ASSIGNMENTS. ODI-1228: Task CLASSIFICATION_UPDATE_CODE_ASSIGNMT (Integration) fails on the target ORACLE connection ORACLE_FUSION. Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FUSION.HZ_CODE_ASSIGNMENTS_U1) violated at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.processError( at oracle.jdbc.driver.T4CTTIfun.receive( at oracle.jdbc.driver.T4CTTIfun.doRPC( at oracle.jdbc.driver.T4C8Oall.


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

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