My Oracle Support Banner

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

Last updated on AUGUST 02, 2022

Applies to:

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


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.

:: ++ 11-AUG-15 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 at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute( at ++ 11-AUG-15 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 faultName: {{}OdiFault} messageType: {{}BPELBulkImportFaultMessage} parts: {{ part= ODI Loading completed but batch status is Error }

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.

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


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.