My Oracle Support Banner

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

Last updated on JUNE 29, 2018

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

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.