My Oracle Support Banner

ORA-00904 "invalid identifier" Error During ODI 12C Mapping Execution Loading Step (Doc ID 2376881.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


In Oracle Data Integrator (ODI), when attempting to execute an integration mapping using "IKM Oracle Insert," the following error occurs:

ODI-1217: Session MAP_name_STG_LOC_Physical_SESS (99604) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1240: Flow Physical_STEP fails while performing a Insert new rows-IKM
Oracle Insert-Load TEMP_DATA operation. This flow loads target table LOAD_REQUEST.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (40)" failed because child task "SERIAL-EU-ORACLEDB_LD_DATALOAD_UNIT (100)" is in error.
ODI-1298: Serial task "SERIAL-EU-ORACLEDB_LD_DATALOAD_UNIT (100)" failed because child task "Insert new rows-IKM Oracle Insert-Load TEMP_DATA (110)" is in error.
ODI-1228: Task Insert new rows-IKM Oracle Insert-Load TEMP_DATA fails on the target connection ORACLEDB_DATALD.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "SOMEDATE_DT": invalid identifier
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.doOall8(
  at oracle.jdbc.driver.T4CStatement.executeForRows(

The executed code is similar to the following:


This same process worked successfully in previous versions of ODI.


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.