My Oracle Support Banner

Encountering a "Non supported SQL92 token at position: 94" Error when Running a Mapping Which Uses IKM SQL Control Append After Upgrade from ODI 11g to ODI 12c (Doc ID 3047567.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

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

Symptoms

After upgrading Oracle Data Integrator (ODI) 11.1.1.9 to ODI 12.2.1.4.x via Upgrade Assistant, a mapping which uses IKM SQL Control Append fails with the following error:

 

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!

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