"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 MARCH 16, 2018

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(T4CTTIoer.java:462)


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