Template-style "IKM Oracle Incremental Update" Generates Incorrect Inline Query With DUAL
Last updated on JANUARY 08, 2018
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Having an Oracle Data Integrator (ODI) 12c Mapping with an expression as source, and an Oracle Datastore as target.
When component-style "IKM Oracle Update" is being used, the Mapping execution succeeds, and the generated SQL code is correct.
When template-style "IKM Oracle Incremental Update" is used instead, the Mapping execution fails, and the SQL code generated on task "Insert flow into I$" is incorrect:
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 hundreds of Community platforms