Import Activity Unsuccessful (Doc ID 2233443.1)

Last updated on FEBRUARY 14, 2017

Applies to:

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

Symptoms

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.


ERROR
-----------------------

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 com.sunopsis.dwg.tools.WaitForChildSession.actionExecute(WaitForChildSession.java:239) at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509) at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44) at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)


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(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.

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