My Oracle Support Banner

"ORA-00942: table or view does not exist & ORA-02063: preceding line from <NAME>" Errors Received when Executing ODI 12c Mapping with DBLINK LKM (Doc ID 2500993.1)

Last updated on JULY 02, 2024

Applies to:

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

Symptoms

A mapping which has been configured in Oracle Data Integrator (ODI) 12.2.1.2.x  or 12.2.1.3x makes use of a Loading Knowledge Module (LKM) with DBLINK functionality.

When the mapping is executed via ODI Studio, the following error is received:

This issue can be reproduced at will with the following steps:

  1. Open ODI Studio
  2. Locate and open or create a mapping which pulls one table from each of two different source databases, joins the source tables, and inserts the data into a third (target) database
  3. Attempt to run the mapping and observe the error stack reported above.

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!

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