Not Able To Upload Customers Account Site Usage Using Template (Doc ID 2049344.1)

Last updated on AUGUST 02, 2022

Applies to:

Symptoms

Not able to upload customers account site usage using template

There is no error in the output but still the site usage is not populated.
 

ERROR
-----------------------
:: ++ 11-AUG-15 11.35.03.585491 AM +00:00:ODI-1226: Step OdiWaitForChildSession 43 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 ++ 11-AUG-15 11.35.03.643587 AM +00:00:355503 - ACCTSITEUSES_LOAD: ODI-1217: Session ACCTSITEUSES_LOAD (355503) fails with return code 12899. ODI-1226: Step ACCTSITEUSE_INSERT_OSR fails after 1 attempt(s). ODI-1240: Flow ACCTSITEUSE_INSERT_OSR fails while performing a Integration operation. This flow loads target table HZ_ORIG_SYS_REFERENCES. ODI-1228: Task ACCTSITEUSE_INSERT_OSR (Integration) fails on the target ORACLE connection ORACLE_FUSION. Caused By: java.sql.SQLException: ORA-12899: value too large for co::::2015-08-11T11:35:14::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 Loading completed but batch status is Error }

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Putting file on content server using the Tools -> File import and export.
2) Loading the records to interface through "Load File to Interface" process.
3) Importing records using Batch from Customer Data management -> Data Import.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import customer site uses.

Cause

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