Program View Install fails if Source Table Includes both CDR$ and CDR_ Columns
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
two columns CDR$UNPIVOT$SKEY and CDR_UNPIVOT_SKEY.
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.
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