Incorrect Column Alias Is Generated in the Code of ODI 12c Mappings when Journalization (CDC) Is Being Used

(Doc ID 2411379.1)

Last updated on JUNE 28, 2018

Applies to:

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

Symptoms

Incorrect Column Alias (RN_SUBSCRIBER, JRN_FLAG and/or JRN_DATE) is generated by Oracle Data Integrator (ODI) 12c when executing a Mapping which performs Join operations on a Journalized Datastore.

Snippet of code generated by ODI:

...
<table>.COL1 as JRN_SUBSCRIBER,
...

Expected code:

...
<table>.COL1 as COL1,
...

 

Changes

 

Cause

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