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 12.2.1.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.2.6, 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(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
  ...

The executed code is similar to the following:

SELECT
  INLINE_VIEW.SOMECOLUMN1 ,
  ...
  (SRC_DB."DATA_LOAD".F_DATE_FIX( SOMEDATE_DT )) ,
  ...

This same process worked successfully in previous versions of ODI.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.