ODI KM "SOURCE_ACCESS_DB_LINK" Value Ignored If Over 30 Characters in Length (Doc ID 3006627.1)

Last updated on MARCH 11, 2024

Applies to:

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

Symptoms

When using an Oracle Data Integrator (ODI) knowledge module for Oracle Database DBLINK connections, the SOURCE_ACCESS_DB_LINK option is ignored if the value is greater than 30 characters. In that case, a default database link name is used.

For example:

If SOURCE_ACCESS_DB_LINK is set at more than 30 characters, set as "DBLinkname1abcdefghijklmnopqrstuvwxyzab" and Create_DB_Link is set to False, then ODI ignores the value as uses the default value.
If SOURCE_ACCESS_DB_LINK as set at less than or equal to 30 characters, then it works as expected, using the value as given.

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.

ODI KM "SOURCE_ACCESS_DB_LINK" Value Ignored If Over 30 Characters in Length (Doc ID 3006627.1)

Applies to:

Symptoms

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!