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 JUNE 16, 2022

Applies to:

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


In Oracle Data Integrator (ODI) Studio, 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.




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.