My Oracle Support Banner

"ORA-00903: invalid table name" Error Received when Running a Mapping that Contains a Dataset Component on the Filter WHERE Clause (Doc ID 2503393.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) Studio 12.2.1.3.0, running a mapping that references a data set in the filter WHERE clause results in the following error:

ODI-1228: Task Insert flow into I$ table-IKM Oracle Incremental Update- fails on the target connection <CONNECTION>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

Changes

 

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