Runtime Errors when ODI Uses Datastore Aliases Such as ADD, OFF, USE ... (Doc ID 423983.1)

Last updated on DECEMBER 08, 2023

Applies to:

Oracle Data Integrator - Version 4.1.01.05 to 11.1.1.9.99 [Release 4.1.01 to 11gR1]
Information in this document applies to any platform.

Symptoms

Case 1

When building an Oracle Data Integrator (ODI) Integration Interface it appears that certain joins between Source Datastores are inadequately generated and appear to be incomplete ("hanging"). Although they are correctly specified, the Tables are not joined at runtime.

Case 2

When running an ODI Integration Interface, an

Note that one of the Source Datastores has been attributed the "ADD" alias.

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.