Program View Install fails if Source Table Includes both CDR$ and CDR_ Columns

(Doc ID 2405573.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.4.7 version,

When attempting to create a Program View when using transformation as a source which has
an Unpivot table which source is another transformation which has an Unpivot table,
the install fails with the following error:

ERROR
-----------------------


The problem was isolated to the case when a Program View is using as a source a table including
two columns CDR$UNPIVOT$SKEY and CDR_UNPIVOT_SKEY.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Create a transformation which has an Unpivot table.
    At LSH level, this Unpivot table has a column named CDR_UNPIVOT_SKEY of type VARCHAR2(4000).
2. Create a new transformation using as a source the Unpivot table from step 1.
    At LSH level, a CDR$UNPIVOR$SKEY column of type VARCHAR2(4000) is added.
3. Create a Program View using as a source the transformation with Unpivot table defined at step 2.

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