"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 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Generic Linux
Generic UNIX

Symptoms

Using :OBIA 11.1.1.10.2 with ODI 11.1.1.9.0

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)
  ...

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