My Oracle Support Banner

Incorrect Data Lineage Values after Reordering Primary Key Columns (Doc ID 2550171.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On DMW 2.4.8 version,

ACTUAL BEHAVIOR
---------------
After changing the primary key columns order, the Data lineage is not showing the correct primary key column values.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Create a Study
Setup:

The Model: SRC1   Table: TAB1
Constraint Type: Primary Key  Constraint column : COL1, COL2

2) Data  Loaded:

DISCREPANCY_EXISTS   COL1  COL2  DUPLICATE LAST_MODIFICATION
No                   1     Test1 N         26-Apr-2018 11:27:25 PM
No                   2     Test2 N         26-Apr-2018 11:27:25 PM
No                   3     Test3 N         26-Apr-2018 11:27:25 PM
No                   4     Test4 N         26-Apr-2018 11:27:25 PM
No                   5     Test5 N         26-Apr-2018 11:27:25 PM

Data Lineage:
=============
Name           Is Masked    Is Staging  Value     Datatype        Preferred Path    Primary Key
SRC1.TAB1.COL1                           1        VARCHAR2(10)    No                COL1:1,COL2:Test1,CDR$DUP_NUM:1

3) Modify the Constraint Column to: COL2,COL1

4) Install

5) Check the Data Lineage and found the following:

Data Lineage
==========
Name         Is Masked    Is Staging  Value     Datatype        Preferred Path     Primary Key
SRC1.TAB1.COL1                         1        VARCHAR2(10)    No                 COL2:1,COL1:Test1,CDR$DUP_NUM:1


Conclusion:
   The Primary Key in the Data Lineage screen was reordered based on the modified Constraint column however values against primary key columns for
source is not reflecting properly.



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
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.