My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

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 "<TABLE>_c" IS
SELECT
/* <MAPPING>.<TABLE>.INOUTGRP1 */
"<TABLE>"."TYPE" "O_ID$1",
"<TABLE>"."L_RATE" "IN_TYPE",
"<TABLE>"."START_DATE" "H_TYPE$1",
"<TABLE>"."END_DATE" "U_FLAG$1",

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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