Trying To Import Customers Using TCA Bulk Import Program But This Fails Abruptly (Doc ID 1991789.1)

Last updated on MARCH 20, 2015

Applies to:

Oracle Fusion Trading Community Model Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion, 11.1.9.2.0 version, trying to import customer and the TCA bulk import program to fail abruptly. getting the following error:


ERROR
-----------------------
ERROR_MESSAGE
:: ++ 12-FEB-15 01.03.35.822802 AM +00:00:ODI-1226: Step HZ_INTG_VALIDATION fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails. at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53) at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1127) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:594) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) ++ 12-FEB-15 01.03.36.081739 AM +00:00:175503 - HZ_INTG_VALIDATION: ODI-1217: Session HZ_INTG_VALIDATION (175503) fails with return code 7000. ODI-1226: Step SA_HZ_INTG_VALIDATION version 001 fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails. at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53) at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1127) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessS::::2015-02-12T01:03:41::FoundationBulkImportProcessComposite::com.oracle.bpel.client.BPELFault: faultName: {{http://xmlns.oracle.com/apps/crm/hz/bulkImport/FoundationBulkImportProcessComposite}OdiFault} messageType: {{http://xmlns.oracle.com/apps/crm/hz/bulkImport/FoundationBulkImportProcessComposite}BPELBulkImportFaultMessage} parts: {{ part= ODI Validation completed but batch status is Error }


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Schedule processes
2. Go to Load and import data
3. Load the file and the process ends with error
4. Reviewed the log and observed the error described.


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