Code Generated With Incorrect Column Aliases in OWB 11.2 (Doc ID 1368419.1)

Last updated on MARCH 02, 2015

Applies to:

Oracle Warehouse Builder - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

In OWB 11.2.0.2 and 11.2.0.3, when a mapping contains several columns that are similar in their input/output groups, the code generated contains incorrect column aliases as shown in the below example:

CURSOR "T_T_PRODUCT_LIFE_c" IS
SELECT
/* T_PRODUCT_LIFE.T_T_PRODUCT_LIFE.INOUTGRP1 */
"T_T_PRODUCT_LIFE"."INS_TYPE" "ORGAN_ID$1",
"T_T_PRODUCT_LIFE"."LIFE_RATE" "INS_TYPE",
"T_T_PRODUCT_LIFE"."START_DATE" "HOSPITAL_TYPE$1",
"T_T_PRODUCT_LIFE"."END_DATE" "UNIT_FLAG$1",

 

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