My Oracle Support Banner

Single Patient Viewer Reference Allele and Alternate Allele Columns were Switched (Doc ID 2097972.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Health Sciences Cohort Explorer - Version 3.0 to 3.0.2 [Release 3.0]
Information in this document applies to any platform.


On Oracle Health Sciences Cohort Explorer (TRC) 3.0.2 version,

The content of columns "Reference Allele" and "Alternate Allele" are switched, i.e. for a Variant Type deletion, the "Reference Allele" column is empty (dash) instead of the "Alternative Allele".
The data in W_EHA_VARIANT.replace_tag is correct (order is confirmed to be ref/alt).

It would be expected that the columns "Reference Allele" and "Alternate Allele" to be listed in correct order.

The issue can be reproduced with the following steps:
1. Under Health Sciences Cohort Explorer, go to "Single Patient Viewer" tab;
2. Select "Genomic Data" -> "Variants Found" for a patient, then click "Submit";
3. In the Variants Found section, expand any of the graph items to view a list of variants.
    The content of columns "Reference Allele" and "Alternate Allele" are switched.


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.