My Oracle Support Banner

"ORA-01722: Invalid Number" Error Received when using ODI 11g for Loading a CSV File Generated by Fusion Application"s (Doc ID 2373515.1)

Last updated on FEBRUARY 12, 2021

Applies to:

Oracle Data Integrator - Version to [Release 11gR1]
Generic Linux
Generic UNIX


Using :OBIA with ODI

The following message is received when using an Oracle Data Integrator (ODI) 11g Interface to load into Oracle Business Intelligence Applications (OBIA) CSV data extracted from Oracle Fusion Applications:

ODI-1217: Session <SESSION_NAME> (126891500) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: ODI-1228: Task <TASK_NAME> (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

  at oracle.jdbc.driver.T4CTTIoer.processError(


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.