My Oracle Support Banner

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.


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:


The problem was isolated to the case when a Program View is using as a source a table including

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.


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.